IN

Need to remember that when wanting to allow end users to pick multiple parameters to include an IN statment!!!

gotta use IN (@PARAM) to handle multiple

Example:
WHERE a.value IN (@PARAM)