Non-Full-Text Predicates in Windows SharePoint Services Search SQL Syntax

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

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.

Important

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

LIKE Predicate in Windows SharePoint Services Search SQL Syntax

Literal Value Comparison in Windows SharePoint Services Search SQL Syntax

DATEADD Function in Windows SharePoint Services Search SQL Syntax

Multi-valued (ARRAY) Comparisons in Windows SharePoint Services Search SQL Syntax

NULL Predicate in Windows SharePoint Services Search SQL Syntax