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