Non-Full-Text Predicates in SharePoint Search SQL Syntax
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 |
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 SharePoint Server search scan the entire content index, which may degrade the query's performance.
In this Section
LIKE Predicate in SharePoint Search SQL Syntax
Literal Value Comparison in SharePoint Search SQL Syntax
DATEADD Function in SharePoint Search SQL Syntax
Multivalued (ARRAY) Comparisons in SharePoint Search SQL Syntax