Query forms support the following comparison operators:
| Operator | Description |
|---|---|
| like | Returns records containing a field value that matches the value
you type using one or more wildcard
characters.
If you do not use a wildcard character, Like acts the same as = (equals). This is the default operator for the Primary Criteria tab fields. |
| = (Equal) |
Returns records containing a field value that matches exactly
the value you type.
You cannot use wildcard characters with this operator. |
| > (Greater than) |
Returns records containing a field value greater than the value
you enter. With letters, > refers to alphabetical order
from A to Z. This entry is not case-sensitive; in other words,
"King" is the same as "king", as far as the
system is concerned.
You can use wildcard characters with this operator. |
| < (Less than) |
Returns records containing a field value less than the value
you enter. With letters, < refers to alphabetical order
from A to Z. This entry is not case-sensitive; in other words,
"King" is the same as "king", as far as the
system is concerned.
You can use wildcard characters with this operator. |
| <> or != (Not equal) |
Returns records containing field values that do not match exactly
the value you enter.
You cannot use wildcard characters with this operator. |
| Not like | Returns records containing a field value that does not match
the value you type using one or more % wildcard characters.
If you do not use a wildcard character, Not like acts the same as <> or != (Not equal). Not like does not appear in the drop-down list of operators, but you can type Not like in the operator field. |
Additional Criteria in Query Forms