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.