CODEWITHSUNDEEP
sql-serverfull-text-search
Denis D
Denis D

Reputation: 23

Full text search not work with Prefix 'the'

I have a problem building a query with full text search. In my database there a company table with name column, and one of the company name is 'the acclaimed software company'

If I run the query below, I cannot get any result:

SELECT *
FROM  [dbo].[Company]
WHERE contains([CompanyName], '"the*" and "acclaimed*" and  "software*" and "company*"')

If I run the query without '"the*"', I get the correct result:

SELECT *
FROM  [dbo].[Company]
WHERE contains([CompanyName], '"acclaimed*" and  "software*" and "company*"')

Someone could help me? Thanks

Upvotes: 0

Views: 71

Answers (1)

Paul
Paul

Reputation: 1170

"The" is considered a noise word and is thus ignored.

How to configure and manage those, can be found in the docs

Upvotes: 1

Related Questions