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 |
|
danielhai
Yak Posting Veteran
50 Posts |
 Posted - 2002-11-15 : 15:45:44
|
| I was wondering if anyone had a function that would take a search string, and parse it out into a boolean phrase:For instance, FirstName Field is passed 'Dan OR George', and it would output:(FirstName Like '%Dan%' OR FirstName Like '%George%')i have this is coldfusion code already, but would like the equivalent ... I'd rather do the searching in sql ... |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-17 : 22:47:01
|
| You can modify the csv code to return a string.http://www.sqlteam.com/item.asp?ItemID=11499You can also look through the site a some dynamic sql examples and instead of passing Dan Or George pass the entire where clause to you stored procedure and then use sp_ExecuteSQL.Edited by - ValterBorges on 11/17/2002 22:50:18 |
 |
|
|
|
|
|
Search term user-defined function