InterSystems SQL Reference
ANY


scalarexpression comparisonoperator ANY (subquery)
scalarexpression  A scalar expression (most commonly a data column) whose values are being compared with the result set generated by subquery. 
comparisonoperator  One of the following comparison operators: = (equal to), <> or != (not equal to), < (less than), <= (less than or equal to), > (greater than), >= (greater than or equal to), [ (contains), or ] (follows). 
subquery  A subquery, enclosed in parentheses, which returns a result set that is used for the comparison with scalarexpression. 