shots/contents.gifshots/index.gifshots/prev1.gifshots/next1.gif

Other Relational Operators

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.

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.

shots/contents.gifshots/index.gifshots/prev1.gifshots/next1.gif