BETWEEN Condition

For a BETWEEN test to be TRUE, the value of the expression on the left of the BETWEEN keyword must be in the inclusive range of the values of the two expressions on the right of the BETWEEN keyword.

NULL values do not satisfy the condition, and you cannot use NULL for either expression that defines the range.

The following examples show some BETWEEN conditions:

order_date BETWEEN '6/1/97' and '9/7/97'

zipcode NOT BETWEEN '94100' and '94199'

EXTEND(call_dtime, DAY TO DAY) BETWEEN 
   (CURRENT - INTERVAL(7) DAY TO DAY) AND CURRENT

lead_time BETWEEN INTERVAL (1) DAY TO DAY 
   AND INTERVAL (4) DAY TO DAY

unit_price BETWEEN loprice AND hiprice