Non-Full-Text Predicates in SharePoint Foundation Search SQL Syntax

[This documentation is preliminary and is subject to change.]

The SQL syntax for Search in Windows SharePoint Services supports five non–full-text search predicates, as described in the following table.

Non-full-text predicate	Description
LIKE predicate	Column values are compared using simple pattern matching with wildcards.
Literal value comparison	Column values are compared against string, date, time stamp, numeric, and other literal values. This predicate supports inequalities such as greater than (>), and less than (<).
Multivalued (ARRAY) comparisons	Multivalued columns are compared against a multivalued array of literal values.
NULL predicate	Column values that are undefined for the document can be detected using the NULL predicate.

Caution

Search queries using the NULL predicate can require that Search scan the entire content index, which may degrade the query's performance.

In this Section