Friday, December 03, 2004

Multiple search terms (SQL)

When searching for data in a column, you may want to perform an OR AND or exact term on a user supplied string. When you use LIKE, the column needs to contain the whole text string, which is not always what you want. One way round this is to use a stored procedure as outline by Jeff Smith (Dr. Cross Join) a member of SQLTeam.com - Search Logic For Multiple Search Terms

1 comment:

Tito Maury said...

Tis the season! I was searching the web and found your entry Multiple search terms (SQL) I really like your site and found it worth time reading through the post. I am looking to publish a comprehensive site ranges many types of historical needlework. All those interested in this area will find this article of interest as it is written from many perspective. Please feel free to take a look at my blog at ms sql programming and add any thing your want.