0 out of 1 rated this helpful - Rate this topic

Full-Text Predicates in SharePoint Search SQL Syntax

SharePoint 2010

SharePoint 2007

Published: May 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

Reference

Non-Full-Text Predicates in SharePoint Search SQL Syntax

WHERE Clause in SharePoint Search SQL Syntax

Change History

Date	Description	Reason
May 2010	Initial publication

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD