I have a parameter allows multiple values. When I use the following SQL in command object, I always get error. Looks like the syntax problem.
Select ...
FROM ...
WHERE ... AND COLUMNNAME in PARAMETERVARIABLE AND...
Can anyone tell how to use parameter with multiples values in the sql query.
Select ...
FROM ...
WHERE ... AND COLUMNNAME in PARAMETERVARIABLE AND...
Can anyone tell how to use parameter with multiples values in the sql query.