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. |