Result value
statements #tsql#statements
Compares a scalar value with a single-column set of values. SOME and ANY are equivalent.
syntaxsql
scalar_expression
Is any valid
expression.
{ = | <> | != | > | >= | !> | < | <= | !< }
Is any valid comparison operator.
Specifies that a comparison should be made.
Is a subquery that has a result set of one column. The data type of the column returned must
be the same data type as
scalar_expression.
TRUE
FALSE
scalar_expression { = |
<>
| != | > | >= | !> |
< | <= | !< }
{ SOME | ANY } ( subquery )