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.


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

Community Additions