Share via

FORMSOF Term in Windows SharePoint Services Search SQL Syntax

  • Article

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Performs matches by using other linguistic forms of the word.

FORMSOF (<generation_type>,<match_words>)

Remarks

The generation type specifies how Search chooses the alternative word forms.

Two values are available:

  • INFLECTIONAL chooses alternative inflection forms for the match words. If the word is a verb, alternative tenses are used. If the word is a noun, the singular, plural, and possessive forms are used to detect matches.

  • THESAURUS chooses words that have the same meaning, taken from a thesaurus.

The <match_words> portion can be one or more words, separated by using commas. The words cannot contain spaces or punctuation, so you do not need to enclose them in quotation marks.

Examples

The following example searches for inflectional matches for the word "run". This example matches documents containing "run", "running", or "ran".

…CONTAINS('FORMSOF(INFLECTIONAL,"run")')

The following example searches for thesaurus matches for the word "happy". This example matches documents containing "happy", in addition to words like "glad", "cheerful", and "pleasant".

…CONTAINS('FORMSOF(THESAURUS,"happy")')

See Also

Reference

CONTAINS Predicate in Windows SharePoint Services Search SQL Syntax