0

I have a problem I have a query that requires multiple values 

SELECT * FROM customer
WHERE department IN (@pValueParm)

the actual values I would like to have are two set for two options if the click "Q&M" should send to the query pValueParm the values E, I "Capital" should send to the query pValueParm the values M, T.

Basically if they click both it should send all 4 E,I,M,T

SELECT * FROM customer
WHERE department IN (E,I,M,T)

I created a Parameter pValueParm and selected "Specify Values Label Q&M and the Values as E,I Label Capital and the values as M,T

However, it is not working. Any ideas what is the best way to accomplish this? Thanks

markpsmith
  • 4,860
  • 2
  • 33
  • 62
Frank InOregon
  • 121
  • 1
  • 2
  • possible duplicate of [Parameterizing an SQL IN clause?](http://stackoverflow.com/questions/337704/parameterizing-an-sql-in-clause) – GSerg Sep 06 '12 at 22:05
  • (I was lazy and picked the oldest duplicate. There are tons of newer ones.) – GSerg Sep 06 '12 at 22:05

0 Answers0