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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Apr 1, 2013, 6:01 AM
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 GilbilePosted Apr 1, 2013, 5:01 AM
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.