CODEWITHSUNDEEP
sql-serverfull-text-searchfreetexttable
jamesmhaley
jamesmhaley

Reputation: 45459

SQl server search, using FREETEXTTABLE (Transact-SQL)

Thanks in Advance.

I am implementing FREETEXTTABLE into a search form. I wanted to know how the following queries would behave and what results would be returned. Also, would like to know if brackets form a valid part of a query.

So, if I search for "Abuse AND (procedure OR legislation)", would this be a valid search query for FREETEXTTABLE? Or would I need to pass in "Abuse AND procedure OR legislation".

My worry is that if I pass in "Abuse AND procedure OR legislation", it will find results that are "Abuse AND Procedure" Or "Legislation" when I want the results that have "Abuse" AND "Procedure OR Legislation".

Thanks in advance for your help.

Upvotes: 1

Views: 1005

Answers (1)

John Sansom
John Sansom

Reputation: 41819

FREETEXTABLE does not interpret the word "AND" as a keyword, like for example when using CONTAINS. Instead it will be considered as a noise word.

FREETEXTABLE uses character-based data types for values that match the meaning, but not the exact wording.

You may insetead wish to look at the use of CONTAINSTABLE as this does allow the use of the keywords AND / OR.

Upvotes: 1

Related Questions