picoSQL - Language reference manual

6.2) BETWEEN predicate

A BETWEEN predicate verifies if a value is contained between two values; the syntax is:

expression-1 [NOT] BETWEEN expression-2 AND expression-3

This predicate, without the NOT operator, is equivalent to:

espressione-1 >= espressione-2 AND espressione-1 <= espressione-3

NOT operator reverses the meaning of the condition.