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.|
|IN||ALL||expression is equal to every literal in the list.|
|ANY||expression is equal to any literal in the list.|
|NOT IN||ALL||expression is not equal to any literal in the list.|
|ANY||expression is not equal to every literal in the list.|
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.