CODEWITHSUNDEEP
sql-serverfull-text-searchcontains
Aysberq Tundra
Aysberq Tundra

Reputation: 13

SQL Server Full Text Search not working for me

I have problem with Full Text Search in SQL Server. My query:

Select [Name] From [POI] Where Contains([Name],  N'"bank of*"');

Query returns no rows. But table has several rows that contains "bank of ..." When I delete the word "of" everything works. Please help to solve this problem.

Upvotes: 1

Views: 1650

Answers (1)

hatchet - done with SOverflow
hatchet - done with SOverflow

Reputation: 16257

As described in this other question Dropping noise words in SQL Server 2005 full text indexing, noise words are not included in the indexing. "of" is a noise word, which would explain the behavior you're seeing.

See also:

Configure and Manage Stopwords and Stoplists for Full-Text Search

Noise/Stop Words in SQL Server

SQL Server: no search results caused by noise words

Which includes the suggestion 

ALTER FULLTEXT INDEX ON table
   SET STOPLIST OFF;

Upvotes: 2

Related Questions