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:
ALLExpressions
Field-Expressions