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 - 2000-08-24 : 20:16:03
|
Blain writes "I am trying to pass an unknown number of parameters to a stored procedure to include into a dynamic WHERE statement.
Ex.
WHERE (some_condition) AND (some_condition) and so on...
I only want to have one @param but that param can contain multiple values that can be evaluated as true on a where
Ex.
@param = "AL"
WHERE (State = "AL")
OR
@param = "AL,MA,OK"
WHERE (State = "AL") AND (State = "MA") AND (State = "OK")
How can I do this?"
|
|
|
|
|
|
Passing Multiple Values Through One Parameter