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 |
|
zipman1952
Starting Member
14 Posts |
 Posted - 2003-05-07 : 08:48:01
|
| Ladies and Gentlemen:I am being passed an array from a web page of state abbreviations, and I need to build an 'in' clause in a stored proc based on that array. Example:array = NY, CA, FLIN clause in stored proc should read:where state in ('NY', 'CA', 'FL').I know that somewhere on this site I read how to do this, but I can't remember where, and I would appreciate if someone can point me to the solution.Thanks in advance!kevin |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
zipman1952
Starting Member
14 Posts |
Posted - 2003-05-07 : 11:26:07
|
| Thanks, Valter - that works for me.kevin |
 |
|
|
|
|
|
parsing input parameter as array