February 11, 2011 at 5:14 am
I have a table where I am performing contains search. In some of the cases it is not giving the result, although record is there in the table.
SELECT *FROM WI_ProjectSearchData WHERE CONTAINS(ProjectType,'"*P&L, Cash Flow, and Long Range planning*"')
In above query record is present in the table with data,but contains not returning any record.
What would be the problem.this is a major problem, how do i resolve it.
Any help will be highly appreciated.
April 12, 2011 at 7:14 am
Your Query contains the correct syntax, I don't see a logical reason why it is not returning your record.
I am going to make some assumptions here:
Assuming that you have created your full text catalog.
1) Make sure that you have added the column in question to the catalog
2) Check and make sure that you have the proper Collation Sorting Style.
3) Try rebuilding the catalog
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply