Full-Text Predicates in Enterprise Search SQL Syntax

  • Article

Enterprise 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 Enterprise Search SQL Syntax

FREETEXT Predicate in Enterprise Search SQL Syntax

See Also

Reference

Non-Full-Text Predicates in Enterprise Search SQL Syntax
WHERE Clause in Enterprise Search SQL Syntax