SOME | ANY (SQL Server Compact Edition)
SQL Server 2005
Compares a scalar value with a single-column set of values.
- scalar_expression
-
Any valid expression in Microsoft SQL Server 2005 Compact Edition.
- { = | <> | != | > | >= | !> | < | <= | !< }
-
Any valid comparison operator.
- SOME | ANY
-
Specifies that a comparison should be made.
- subquery
-
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.
