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