Comparison operators

The BETWEEN operator tests if a value is within a specified range. The syntax is as follows:

BETWEEN min AND max

The presence of NULL in a BETWEEN or NOT BETWEEN statement will result in the statement evaluating to NULL.

IS NULL and IS NOT NULL operators test whether a value is null (undefined). Using NULL with IS NULL evaluates to true.

In SQL, a NULL value signifies an unknown value.