Full Text Search string
Posted on 2016-10-29
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.
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.