So I have a parameter called category which has 4 options

Creation

Deletion

Add

Move

 

The user can basically selected one, some or all of the parameters.

I want to then pull back all rows where the category is equal to which ever ones the user selected. How do I do this?

I tried saying where category='?Category but for example when the user enters Creation and Deletion it will just pull back all the creation ones.

 

Any help will be much appreciated.

 

Thanks in advance,

Colman