The Microsoft SharePoint Portal Server Search (SharePointPSSearch) query language supports five non-full-text search predicates. The following table describes these predicates.
|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.