Export (0) Print
Expand All

Using the FREETEXT Predicate

SQL Server 2000

With a FREETEXT predicate, you can enter any set of words or phrases, or even a complete sentence. The full-text query engine examines this text, identifies all the significant words and noun phrases, and internally constructs a query with those terms. This example uses a FREETEXT predicate against a column named description.

FREETEXT (description, ' "The Fulton County Grand Jury said Friday an investigation of Atlanta's recent primary election produced no evidence that any irregularities took place." ') 

The search engine identifies words and noun phrases such as the following:

Words

Fulton, county, grand, jury, Friday, investigation, Atlanta, recent, primary, election, produce, evidence, irregularities

Phrases

Fulton county grand jury, primary election, grand jury, Atlanta's recent primary election

The words and phrases in the FREETEXT string (and their inflectionally generated variations) are internally combined into a query, weighted for proper ranking, and then the actual search is performed.

See Also

FREETEXT

Show:
© 2014 Microsoft