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 |
|
misterish
Starting Member
10 Posts |
 Posted - 2011-03-01 : 12:53:15
|
| Hi,I have a stored proc that accepts a varchar variable called @section. Currently I can pass one value ('3.02'), but ultimately I'd like to pass multiple values with wildcards ('3.02','3.14','3.2%') for use in the IN, like so:WHERE (id = @id) AND (section IN (@section))Obviously, this does not work. How would I accomplish this?Thank you!Joe |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-03-01 : 13:37:35
|
| Have a look at:http://www.sommarskog.se/arrays-in-sql-2005.html |
 |
|
|
|
|
|
How to pass multiple values for use in "IN"