User Guide

174 Developing Web Applications with ColdFusion
The following operators are used for numeric and date comparisons.
Text comparison operators match words and parts of words. The following operators
are used for text comparisons.
Verity Numerical and Date Relational Operators
Operator Description
=Equals
> Greater than
>= Greater than or equal to
<Less than
<= Less than or equal to
VerityText Comparison Operators
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,
specifying "god" will match "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,
specifying "god" will match a document field containing only
"god" and will 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.