Export (0) Print
Expand All

SOME | ANY

SQL Server 2000

Compares a scalar value with a single-column set of values.

Syntax
scalar_expression { = | < > | ! = | > | > = | ! > | < | < = | ! < } 
   { SOME | ANY } ( subquery ) 
Arguments
scalar_expression
Is any valid expression in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE).
{ = | <> | != | > | >= | !> | < | <= | !< }
Is any valid comparison operator.
SOME | ANY
Specifies that a comparison should be made.
subquery
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.
Result Types

bit

Result Value

SOME or ANY returns TRUE when the comparison specified is TRUE for ANY pair (scalar_expression, x) where x is a value in the single-column set; otherwise, returns FALSE.

Show:
© 2014 Microsoft