ASA SQL Reference
SQL Language Elements
Search conditions
The syntax for ANY conditions is
expression compare ANY ( subquery )
where compare is a comparison operator.
For example, an ANY condition with an equality operator,
expression = ANY ( subquery )
is TRUE if expression is equal to any of the values in the result of the subquery, and FALSE if the expression is not NULL and does not equal any of the columns of the subquery. The ANY condition is UNKNOWN if expression is the NULL value, unless the result of the subquery has no rows, in which case the condition is always FALSE.
The keyword SOME can be used instead of ANY.
The syntax for ALL conditions is
expression compare ALL ( subquery )
where compare is a comparison operator.
ANY and ALL subqueries are compatible between Adaptive Server Enterprise and Adaptive Server Anywhere. Only Adaptive Server Anywhere supports SOME as a synonym for ANY.