1

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.

jamesmhaley
  • 44,484
  • 11
  • 36
  • 49

1 Answers1

1

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.

John Sansom
  • 41,005
  • 9
  • 72
  • 84
  • So we could do a standard CONTAINSTABLE to search for: "Abuse AND (procedure OR legislation)". And that would give me the desired results? – jamesmhaley Nov 29 '10 at 12:11