Actian X 11.2 | Boolean Literals

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 on page 223

Last modified date: 04/03/2024