1
Reply

FullText Idx created but when selected no rows are retrieved

Sasidhar Akula

Sasidhar Akula

Jun 10 2015 1:51 PM
352

 Hi, I have created a sample table on my local database on SQL Server 2012, inserted some values, created full text catalog and full text index a this table. After that I have also ran Full population on this table.

It was successfully created but when trying to select records using predicates CONTAIN or FREETEXT, I am not getting any results. I have records with
 "Struc" word in the target column as below statement is giving me results.
Select * from Tbl_Search Where Title like 'Pub%' 

Select * from Tbl_Search Where Freetext(Title,'Pub')

 Could you please  help me if I am missing anything here. Thanks.
 

Answers (1)