602SQL Documentation Index  

BETWEEN Predicate

BETWEEN_predicate ::= expression [ NOT ] BETWEEN expression2 AND expression3

The BETWEEN predicate tells us whether the expression value is between the value of expression2 and expression3. The types of all expressions must be compatible.

It is a simplified way of writing a condition (expression >= expression2) AND (expression =< expression3).


FROM People
WHERE date_start BETWEEN 1.1.1997 AND 31.12.1997