Non-Full-Text Predicates in SharePoint Search SQL Syntax

Last modified: April 21, 2010

Applies to: SharePoint Server 2010

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

Non–Full-Text Predicate


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.

Important note Important

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