Name

BETWEEN — Inclusion within a range

Syntax

image with no caption

Description

The BETWEEN expression checks to see if the value of a test expression is between a minimum expression and a maximum expression, inclusive. The expression is logically equivalent to (test >= min AND test <= max), although the test expression is only evaluated once. The BETWEEN operator will return a logic value of 0, 1, or NULL, under the rules of three valued logic.

See Also

IN, EXISTS