FREETEXT Predicate
Topic Last Modified: 2006-06-13
Use the Structured Query Language (SQL) FREETEXT Predicate as part of a SQL WHERE Clause to loosely match any item having a variation of a word or group of words.
FREETEXT( [" propertyNAME ", ] ' searchspec ' )
The parameter propertyNAME is optional. If not specified, only the message or document body is searched. Use this parameter to search a property marked for Full-Text Indexing in addition to searching the body. Use an asterisk (*) to include all properties marked for full-text indexing.
The property must be a quoted string, such as "urn:schemas:mailheader:to". An asterisk for this parameter is not surrounded by quotation marks.
The parameter searchspec is the string to search for. See Token Formats for usage of single and double quotation marks. This parameter is case-sensitive. You can use a SQL FORMSOF Predicate in this parameter, and the following operators:
| Operator | Operator Word | Operator Symbol |
|---|---|---|
and |
AND |
& |
or |
OR |
| |
Note
The NOT operator is only supported if it follows an AND operator.
Remarks
FREETEXT can only function if Full-Text Indexing is applied to the store being searched.
Common words, such as "and," "is", "but", and "the", also known as noise words, are bypassed in a search.
A group of words can match several items. For example, "garden rose" will match any item containing "garden", "gardening", "gardener", "gardens", "rose", and "roses", but will not match an item containing "gardenia" or "rosebud".