ANY

<field_expr> <rel_op> ANY ( <value_rows> )
( <field_expr_list> ) <rel_op> ANY ( <value_rows> )

The ANY operator compares a given field-expression with a list of values, returning TRUE if any value in the list satisfies the comparison operation, or FALSE if no values satisfy the comparison.


Examples

A. Single field-expression

The following example expression determines whether or not the "Year" field is greater than any value in the specified list: 
Year > ANY (1999; 2000; 2001)

B. List of field-expressions

The following example expression determines whether or not the pair of "Year" and "Age" fields is less than any of the pairs of values in the specified list: 
(Year, Age) < ANY (1999, 30; 2001, 40; 2002, 10)

See also:

ALL
Expressions
Field-Expressions

© 2004 Microsoft Corporation. All rights reserved.