Hi experts,
Below is the string sample which will be passed from UI
"Hello world" Test daterange:10012016-10312016 description:unique
This is what we are expecting as a search in SQL Server full text.
contains(*,'"Hello world"')
contains(*,'test')
contains(description,'unique')
date_of_record between '10012016' and '10312016'
Anything within double quotes is a phrase and description is a name of column in database table.
Any similiar solution or an idea would be very helpful.
Working with charindex, patindex etc..but running out of time, Help very much appreciated.
Thanks,
Ravi
I think yes you can try FTS.
Steps are-
1. Create a full-text catalog, if reqd.
2. Create the full-text index.
3. Modify the list of noise words, if reqd.
4. Modify the thesaurus for the language being used, if reqd.
Below is the really good blog url you can follow-
http://www.sql-server-performance.com/2010/full-text-search-2008/