Operator | Meaning |
ALL | TRUE if all of a set of
comparisons are TRUE. |
AND | TRUE if both Boolean
expressions are TRUE. |
ANY | TRUE if any one of a set
of comparisons are TRUE. |
BETWEEN | TRUE if the operand is
within a range. |
EXISTS | TRUEif a subquery
contains any rows. |
IN | TRUE if the operand is
equal to one of a list of expressions. |
LIKE | TRUE if the operand matches
a pattern. |
NOT | Reverses the value of any
other Boolean operator. |
OR | TRUE if either Boolean
expression is TRUE. |
SOME | TRUE if some of a set of
comparisons are TRUE. |