You can now use subqueries within BETWEEN conditions. A BETWEEN predicate is of the form “A between B and C.”
In Sybase IQ 12.6 and prior versions, “A”, “B”, and “C” all had to be value expressions or columns.
Now, either “B” or “C” or both “B” and “C” can be subqueries. “A” must still be a value expression or column.
For details, see Chapter 3, “SQL Language Elements,” in the Sybase IQ Reference Manual.
