How to Write a Query to Search Multiple Strings From Multiple Columns

Published by: Lisa (4/27/2009 2:18:09 PM)

I am trying to code a special search module for my website and I am lost here. I want to write a fast performing sql query so that it return data from table very fast. I have array of keywords to search from various fields of the table. Can anyone help me in writing such queries?

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

SQL Query to Find List of Open Connection Objects in MS SQL Server >>

<< How can I query two SQL Servers from one application