A.4.5  List Comparison

A value can be compared to a list of values. The result of the comparison depends on what type of comparison is declared. Two list comparison types are supported:

Any
The comparison is successful if the value compares to true with any one of the values on the list.

All
The comparison is successful if and only if the value compares to true with all values on the list.

The following comparison tests if the price is greater or equal to all prices in the group:

price >= all query('all prices')

The 'query' function executes a sub-query and returns the results. It is covered in more detail in a later chapter.

The next condition tests if the state is in one of the states in the list:

state = any query('tristates')

<< A.4.4 Existence Operator © 1996-2013 InetSoft Technology Corporation (v11.5) A.5 Regular Expressions >>