FORMSOF Predicate

FORMSOF Predicate

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release. Use the Structured Query Language (SQL) FORMSOF Predicate as part of a SQLWHERE Clause to find word variations. FORMSOF is typically used within a SQLCONTAINS Predicate or SQLFREETEXT Predicate.

Syntax

FORMSOF( type,"string" [,"string"] )

The parameter type for the Exchange store is always INFLECTIONAL.

The parameter string contains one or more words for the search engine to find variations of those words. Each word must be delimited with double quotation marks and separated by commas.

Remarks

Common words, such as "and," "is", "but", and "the", also known as noise words, are bypassed in a search.

When FORMSOF is within a CONTAINS Predicate or FREETEXT Predicate, the FORMSOF predicate is itself a token and must be delimited by single quotation marks as shown in the following example:

WHERE CONTAINS('FORMSOF(INFLECTIONAL,"photograph", "announce")')

This clause would find any item containing "photography", "photographs", "photographer", "announcer", "announcing", and items with other forms of these words.

Example

Word and Character Matching

Related Topics

• CONTAINS Predicate
• FREETEXT Predicate
• SELECT Statement
• WHERE Clause

Send us your feedback about the Microsoft Exchange Server 2003 SDK.

Build: June 2007 (2007.618.1)

© 2003-2006 Microsoft Corporation. All rights reserved. Terms of use.