Boolean constants

A Boolean constant specifies the keyword TRUE or FALSE, which represents the corresponding truth value. An unknown truth value can be specified using CAST(NULL AS BOOLEAN).

When a Boolean value (TRUE, FALSE, ON, OFF) is used in a context where it could be interpreted as an identifier, such as a column name, cast a string constant representing the value to Boolean.

CAST('TRUE' AS BOOLEAN)
CAST('off' AS BOOLEAN)

Syntax alternatives: ON is a synonym for TRUE. OFF is a synonym for FALSE.