User Guide

Using Query Expressions 293
You use the following operators for numeric and date comparisons:
The following relational operators compare text and match words and parts of
words:
Operator Description
= Equals
> Greater than
>= Greater than or equal to
< Less than
<= Less than or equal to
Operator Description
CONTAINS Selects documents by matching the word or phrase you specify
with the values stored in a specific document field. Documents are
selected only if the search elements specified appear in the same
sequential and contiguous order in the field value; for example,
“god” matches “God in heaven,” “a god among men,” or “good god”
but not “godliness,” or “gods.”
MATCHES Selects documents by matching the query string with values stored
in a specific document field. Documents are selected only if the
search elements specified match the field value exactly. If a partial
match is found, a document is not selected; for example, “god”
matches a document field containing only “god” and does not
match “gods,” “godliness,” or “a god among men.”
STARTS Selects documents by matching the character string you specify
with the starting characters of the values stored in a specific
document field.
ENDS Selects documents by matching the character string you specify
with the ending characters of the values stored in a specific
document field.
SUBSTRING Selects documents by matching the query string you specify with
any portion of the strings in a specific document field; for example,
“god” matches “godliness,” “a god among men,” “godforsaken,” and
so on.