Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
last
Starting Member
25 Posts |
 Posted - 2009-05-19 : 10:14:34
|
| I have managed to create a query with where in the where clause it uses LIKE to search the Parameter values in SSRS. This works Fine with a single value but the minute i use Multiple values I get an error. I know that it has to do with string deleimited values but I only know how to use MultiValue parameters by using the In keyword.Can anybody help me with a simple example or point me to a page where i can find such an example. I have searched through google and so far i have come up empty handed. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-19 : 10:39:55
|
| you can make query like thisWHERE ',' + @YourParameter + ',' LIKE '%,' + YourField + ',%' |
 |
|
|
|
|
|
Use LIKE in a MULTIVALUE Parameter