A.4.2 In Operator
The 'in' operator tests if a value is one of the values in a given list. In the simplest form, the value list is given directly in the condition. Each value in the list can be either a constant or an expression that returns a scalar value.
state in ('NY', 'NJ')
In SQL, the list can be the result of a sub-query. This is also supported in Style Studio queries. However, the sub-query has a different syntax. The details for using sub-queries are discussed later.
state in (query('tristates'))
In addition to supporting sub-queries in the 'in' operation, the list value can come from any named value, such as a variable or a sub-selection.
Like the 'between' operator, there is a shorthand for adding a logic negation to the condition.
state not in ($(tristates_variable))
| << A.4.1 Between Operator | © 1996-2013 InetSoft Technology Corporation (v11.4) | A.4.3 SQL Pattern Matching Operator >> |