Share via

Full-Text Predicates 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.

The Windows SharePoint Services Search query language supports two full-text search predicates. The CONTAINS predicate performs comparisons on columns that contain text. The CONTAINS clause can perform matching on single words or phrases, based on the proximity of the search terms. In comparison, the FREETEXT predicate is tuned to match the meaning of the search phrases against text columns.

In This Section

CONTAINS Predicate in Windows SharePoint Services Search SQL Syntax

FREETEXT Predicate in Windows SharePoint Services Search SQL Syntax