FREETEXT Predicate

The FREETEXT predicate is used to determine whether or not values in full-text registered columns reflect the meaning, rather than the exact words, specified in the predicate.

The FREETEXT predicate syntax is as follows:

This is a basic form of natural language query, where the index engine internally breaks the freetext string into a number of search terms, generates the stemmed form of the words, assigns heuristic weighting to each term, and then finds the matches.

Here is an example of a FREETEXT predicate used in a WHERE clause.

WHERE FREETEXT (articles, ' Who have been the most  

    valuable players for the Montreal Canadien? ' )