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 |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2011-02-10 : 04:48:54
|
| I am trying for a boolean search.the problem is the user can pass any number of search strings to SP.First is to figure out how many search strings are passed, in case if the search strings are 4 numbers within a parameter seperated by a comma.@OrOper = 'AD345,TRY234,JACOBS32,APB234'then it has to do 4 times this way:where table1.Orderno = 'AD345' or table1.Orderno = ''TRY234' or table1.Orderno = 'JACOBS32' or table1.Orderno = 'APB234'On the Sp side, Is it possible, to handle this.Thank you very much for the helpful info. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Boolean search condition