Creates a record stream containing records with values that fall
within a range you specify.
The BETWEEN conditional expression is true (records are included
in the stream) if the first value expression is between the
second and third value expression, or equal to one of them.
If you precede the BETWEEN expression with the optional NOT
qualifier, the condition is true if there are no records within
the range you specify with the second and third value expression.
The BETWEEN conditional expression sorts records in ascending
order by default. For information on sorting records see the
entry on the SORT statement.
Additional Information:
explode
extract