Returns True if a value is between two given values
Format
expression [ NOT ] BETWEEN expression AND expression
Remarks
Checks if a value is between two given values. The range is inclusive.
y BETWEEN x AND z
is the same as
x <= y AND y <= z
y NOT BETWEEN x AND z
is the same as
NOT ( y BETWEEN x AND z )
Example:
CurrentValue BETWEEN ZeroScale AND FullScale