Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/boolean.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

Boolean Type

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

The boolean type can have three states: true, false, and unknown. The SQL NULL value represents unknown. You can represent boolean constants in SQL queries with the SQL key words TRUE, FALSE, and NULL.

A comparison or a similar function call can result in a boolean value. You can also use logical operators to combine boolean values.

To parse a boolean from a string, use one of these strings.

True	False
`true`	`false`
`yes`	`no`
`on`	`off`
`1`	`0`
`t`	`f`
`y`	`n`

Data 360 SQL ignores leading or trailing whitespace and isn’t case-sensitive. To use the string representations, provide the generic string-literal constant syntax. For example, ‘yes’::boolean.

Data 360 SQL can’t automatically infer the type of NULL literals. To prevent errors, explicitly cast NULL to boolean. For example, NULL::boolean.

Converting a boolean to a string always emits either true or false, as shown in this example.

The table test1 is defined as:

a	b
true	sic est
false	non est

Column a is a boolean value and column b is a text value.

Results:

a	b
true	sic est
false	non est

Results:

a	b
true	sic est