FullText Index first Match position

61 views Asked by At

I want to do FulltextSearch columns in a table to find CompanyInfo that use keyword "Internet Of things" and at what position in Company Description is this word found.

Company table has ID, CompanyName, briefdescription_company. I have built FullText Index on this column with default stoplist.

I want to do this

CONTAINSTABLE(dbo.Company, briefdescription_company,'ISABOUT("Internet Of things" weight(.1))',LANGUAGE N'English',1000000) as fti 

and find the position of the first match only.

How can i do this?

Thanks Rashmi

0

There are 0 answers