Static IN predicate transformations

A static IN list predicate is one in which the IN list is composed entirely of constants. Derby calculates the minimum and maximum values in the list and transforms the predicate into three new predicates: the original IN predicate, one that uses the >= operator, and one that uses the <= operator. The second and third are optimizable. For example:
orig_airport IN ('ABQ', 'AKL', 'DSM')
is transformed into
orig_airport IN ('ABQ', 'AKL', 'DSM')
AND orig_airport >= 'ABQ'
AND orig_airport <= 'DSM'
Related reference
BETWEEN transformations
LIKE transformations
OR transformations