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.
FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0 [ Boolean_Operator FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0 ]...
| 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. |
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