Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: SharePoint Server 2010
SharePoint Server search SQL syntax 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 SharePoint Search SQL Syntax
FREETEXT Predicate in SharePoint Search SQL Syntax