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 th

Solution 1:

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 ONtableSET STOPLIST OFF;