I have an SQL query that has a statement like
where regionid in (tblpeople.region)
where the results from tblpeople.region could be something like 3913 or something like 3913, 3914.
It works just fine when it is a single variable but multiples gives me the error Conversion failed when converting the varchar value '3913,3914' to data type int. How do I go about fixing this?