The standard Any predicate is supported with an expression list or a subquery. It may be used with a comparison operator or with the In / Not In or Like / Not Like predicates. The following are some examples of the SQL generated for these cases.
expression = ANY (1, 2), is equivalent to: expression = 1 OR expression = 2 expression IN ANY (1, 2), is equivalent to: expression IN (1, 2) and to above expression LIKE ANY ('%string%', '%string%'), is equivalent to: expression LIKE ('%string%') OR expression LIKE ('%string%')
When dragging an Any operator into a variable, the following tree element is created.
Any number of Columns and/or other expressions can be moved into the Expressions folder within the tree.
There are no special properties for the Any operator.