ALL

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

The ALL operator compares a given field-expression with a list of values, returning TRUE if all values in the list satisfy the comparison operation, or FALSE if not all values satisfy the comparison.


Examples

A. Single field-expression

The following example expression determines whether or not the "Year" field is greater than all the values in the specified list: 
Year > ALL (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 all the pairs of values in the specified list: 
(Year, Age) < ALL (1999, 30; 2001, 40; 2002, 10)

See also:

ANY
Expressions
Field-Expressions

© 2004 Microsoft Corporation. All rights reserved.