FORMSOF Predicate
Topic Last Modified: 2006-06-13
Use the Structured Query Language (SQL) FORMSOF Predicate as part of a SQL WHERE Clause to find word variations. FORMSOF is typically used within a SQL CONTAINS Predicate or SQL FREETEXT Predicate.
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.