602SQL Documentation Index  
<­Generalized Comparisons UpConditions and Predicates IN Predicate­>

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).

Example:

SELECT * 
FROM People
WHERE date_start BETWEEN 1.1.1997 AND 31.12.1997
<­Generalized Comparisons UpConditions and Predicates IN Predicate­>