The BETWEEN predicate can be used to determine if a value is within a specified value range or not. The first expression specifies the lower bound of the range and the second expression specifies the upper bound of the range.

The predicate evaluates to true if the value is greater than or equal to the lower bound of the range and less than or equal to the upper bound of the range.

Syntax

This is the syntax for a BETWEEN predicate.

 expression [ NOT ] BETWEEN expression AND expression

Example

salary BETWEEN 20000.00 AND 100000.00