In addition to the CONTAINS operator, there are other relational operators
that you can use to search document fields (such as TITLE or AUTHOR) that have
been defined in the collection. The following operators can be used to search for
alphabetic strings in document fields.
Other Relational Operators
Operator
| Description
|
MATCHES
| Selects documents by matching the character string you specify with values
stored in a specific document field. For example, title <MATCHES> verity finds documents where the entire title field consists of “verity” in upper or lower case.
|
STARTS
| Selects documents by matching the character string you specify with the
starting characters of values stored in a specific document field. For example, title <STARTS> verity finds documents where the title field begins with “verity” in upper or lower case.
|
ENDS
| Selects documents by matching the character string you specify with the ending
characters of values stored in a specific document field. For example, title <ENDS> verity finds documents where the title field ends with “verity” in upper or lower case.
|
SUBSTRING
| Selects documents by matching the character string you specify with a portion
of the strings of values stored in a specific document field. For example, title <SUBSTRING> veri finds documents where the title field has the string “veri” in upper or lower case.
|
To search for numeric values in document fields, you can use the greater than (>), less than (<), or equal to (=) operators. See Searching for Dates in Fields for details.