You can use BETWEEN( ) or INLIST( ) in the following two forms: eIndex BETWEEN(eIndex, eExpr, eExpr) -or- eExpr INLIST(eIndex, eExpr)What is the leading eExpr?? The SQL syntax lets you:
eIndex IN ( eExpr, eExpr, ...)
The INLIST() function *is* optimizable isn't it??