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.5) A.4.3 SQL Pattern Matching Operator >>