When a list of literals is used with quantifiers and comparison operations or IN/NOT IN predicates, the results are determined as follows.
| IF the predicate is … | AND specifies … | THEN the result is true when … |
|---|---|---|
| a comparison operation | ALL | the comparison of expression and every literal in the list produces true results. |
| ANY | the comparison of expression and any literal in the list is true. | |
| SOME | ||
| IN | ALL | expression is equal to every literal in the list. |
| ANY | expression is equal to any literal in the list. | |
| SOME | ||
| NOT IN | ALL | expression is not equal to any literal in the list. |
| ANY | expression is not equal to every literal in the list. | |
| SOME |
For comparison operations, implicit conversion rules are the same as for the comparison operators.
If expression evaluates to NULL, the result is considered to be unknown.