This documentation is archived and is not being maintained.

Non-Full-Text Predicates

SharePoint 2003

The Microsoft SharePoint Portal Server Search (SharePointPSSearch) query language supports five non-full-text search predicates. The following table describes these predicates.

Non-full-text predicate Description
LIKE predicate Column values are compared using simple pattern matching with wildcards. The pattern matching of the LIKE predicate is simpler than that of the MATCHES predicate, but not as powerful.
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 ('<').
MATCHES predicate Column values are compared using regular expression matching. The regular expression capability of the MATCHES predicate is more flexible and powerful than that of the LIKE predicate.
Multi-valued (ARRAY) comparisons Multi-valued columns are compared against a multi-valued array of literals.
NULL predicate Column values that are undefined for the document can be detected using the NULL predicate.

Important  Search queries using the NULL or MATCHES predicates can require that SharePointPSSearch scan the entire catalog, which may degrade the query's performance.

Related Topics

Full-Text Predicates