Transact-SQL Reference
ANY
Compares a scalar value with a single-column set of values. For more information, see
SOME | ANY
.