I have a report parameter, @antibiotics, which presently allows the user to select one value from a dropdown list. I then use this parameter to search a string column using LIKE. So far, this all works great. So my WHERE statement looks like this presently:
Where Notes LIKE '%' + @antibiotics + '%'
Now I want to allow users to select multiple values for @antibiotics. So I made the parameter multi-select.
But now I am lost on how to construct my WHERE statement. I tried using combinations of LIKE and IN but nothing works.
It works if I only select one value from my dropdown list. But if I select more than one value, I get a syntax error near "," or something. Does anyone know how I can accomplish this?
View Complete Post