Range check used to test whether an expression is within a range of values. This operator is inclusive, so it includes the start and end values of the range. The values can be of textual, numeric type, or dates
If the base table is LINEITEM, base column is L_SHIPDATE, from value is 1993-10-07, and to value is 1994-02-08, then the check is defined as,LINEITEM.L_SHIPDATE BETWEEN (‘1993-10-07’, ‘1994-02-08’).
Here the base column data less than 1993-10-07 and greater than 1994-02-08 are identified as invalid.
Below are the possible range conditions: