... operand [NOT] BETWEEN operand1 AND operand2 ...
A logical expression with the language element BETWEEN checks where an interval belongs.
The logical expression checks, whether the content of an operand is within a closed interval. The logical expression is equivalent to the following link of logical expressions with Boolean operators:
... [NOT] ( operand >= operand1 AND operand <= operand2 ) ...
The rules for both comparisons are described in relational operators for all data types.
The addition NOT is possible since release 6.10.
For operand, operand1 and operand2, you can use data objects, installed functions (since release 6.10) and functional methods. The latter use the return value as operand.