Non-Full-Text Predicates
The SharePoint Portal Server query language supports six non-full-text search predicates. The following table shows these predicates and a brief description of each.
| 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 but less powerful than that of the MATCHES predicate. |
| Literal value comparison | Column values are compared against string, date, timestamp, 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. |
| Multivalued comparisons | Multivalued columns are compared against a multivalued array of literals. |
| NULL predicate | Column values that are undefined for the document can be detected using the NULL predicate. |