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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-17 : 17:29:50
|
Michael writes "I am trying to write a stored procedure with a WHERE clause that uses the IN predicate. Furthermore, I want the values to come from a variable passed from an ASP page.
When I code out the clase without the variable it works fine:
WHERE ItemCode IN (100,101,103)
When I try to get the values from a variable, the procedure returns zero rows:
WHERE ItemCode IN (@ItemCode)
I looked at other articles in this site and have not been able to find something that fits this particular issue. It seems like there would be a simple solution, but I can not find it.
Thanks,
Mike" |
|
|
|
|
|
Getting a CSV into a WHERE clause