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.
Variable Creation > Input > Variables: SQL Elements pane - Logical > Any
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.