how to do multiple keyword searching using sql query

Question

Hi All

I have a one big issue in query.

I want to get records from description fields using multiple keywords search.

Keywords like "how long india computer website"

Any key word will be apply for searching in "description" field.

Jignesh Trivedi · Answer

hi agree with Vishal you may also use FreeText feature of SQL Server Please refer http://msdn.microsoft.com/en-us/library/ms176078.aspx you can also write your own logic to achive this. http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-search-for-all-words-inclusive-wi hope this will help you.

Vishal Gilbile · Answer

Hello Friend You could make use Of Full Text Search utility provided by sql server. It will help you to improve performance also while searching. Hope that solves your problem. With Regards Vishal Gilbile.