SQL Reference Guide > SQL Reference Guide > Understanding SQL Data Types > Literals > Boolean Literals
Was this helpful?
Boolean Literals
The SQL literals FALSE and TRUE can be used in expressions, including on the right side of an assignment. Boolean values or expressions can be tested against those literals using the IS operator. For example:
WHERE boolean_value IS TRUE
For input, the literals FALSE and TRUE are accepted, without case sensitivity.
More information:
IS TRUE, IS FALSE, IS UNKNOWN Predicates
Last modified date: 01/30/2023