FREETEXT Predicate

A FREETEXT query performs a best match of the specified words and phrases. It works by finding rows in which the terms and phrases match the meaning, rather than the exact wording of the query. A FREETEXT query ignores Boolean, proximity, and wildcard operators.

Note: It is illegal to place NOT before a FREETEXT predicate that begins with a WHERE clause.

Syntax

FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0
[ Boolean_Operator FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0 ]...

Elements

Column_Reference   Specifies the column name (alias). Its data type must be compatible with the format of the Free_Text_String specified.
   
Free_Text_String   Specifies the literal of type Basic String to match the meaning from.
   
Boolean_Operator   Specifies the boolean operator to use, following the precedence rules previously stated, that combines the FREETEXT predicates.

Examples

The following example returns files in which the Contents mention Microsoft Excel, printing worksheets, and pasting worksheets.

...WHERE FREETEXT('how do I print in Microsoft Excel') > 0
     OR FREETEXT('how can I paste a worksheet into another file') > 0

© 1997 by Microsoft Corporation. All rights reserved.