SOME | ANY (SQL Server Compact Edition)

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

Syntax

scalar_expression { = | < > | ! = | > | > = | ! > | < | < = | ! < } 
   { SOME | ANY } ( subquery ) 

Arguments

  • 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.

Result Types

bit

Return 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.