| AND (+) |
The search terms must occur together in
the field for a match. |
| OR (,) |
Either one or both of the search terms
must occur in the field for a match. |
| NOT (#) |
Use NOT to locate all documents that do
not contain the search term. You can also use NOT with AND and OR, (for
example Boston AND NOT Brookline). |
| WITHOUT |
This is the same as AND NOT. |
| * |
Use the asterisk to replace any number
of characters in the search term with a wild card, (for example SMITH* or
*BURG). You can include only two asterisks per search term. |
| ? |
Use the question mark to replace one character
in the search term, (for example, SM?TH). You can include as many occurrences
as you want. |
| < x |
Searches for less than x. |
| > x |
Searches for greater than x. |
| <= x |
Searches for less than or equal to x. |
| >= x |
Searches for greater than or equal to x. |
| x TO y |
Searches for the range from x to y, inclusive. |
| x .. y |
Searches for the range from x to y, inclusive. |
| <> x |
Searches for not equal to x. |
| NONE |
Searches for all documents for which this
field is empty. |
| ALL |
Searches for all documents that contain
data in this field. |