Operator | Meaning |
= | Equal. |
<> | Not Equal. |
> | Greater Than. |
>= | Greater Than or Equal. |
< | Less Than. |
<= | Less Than or Equal. |
Like | Matching a pattern. |
Not Like | Not matching a pattern. |
Is NULL | Equal to NULL. |
Is Not NULL | Not Equal to NULL. |
Between | Range of values between a lower and upper bound. |
In | A member of a set of specified values or a member of a subquery. |
Exists | True if a subquery returned at least one record. |
Any | Compares a value to each value returned by a subquery. Any must be prefaced by =, <>, >, >=, <, or <=.=Any is equivalent to In. |
All | Compares a value to each value returned by a subquery. All must be prefaced by =, <>, >, >=, <, or <=. |