Categories: Boolean, Datatype

IS [NOT] TRUE

Tests whether the input expression is either true or not true. If true in either case, returns a value of true. Alias for the function ISTRUE/ISNOTTRUE.

Syntax

IS [NOT] TRUE(expression int64) → boolean

• expression: Input expression.

Examples

ISTRUE example

SELECT ISTRUE(1)
-- True

IS [NOT] TRUE(expression boolean) → boolean

• expression: Input expression.

Examples

ISTRUE example

SELECT ISTRUE(FALSE)
-- False

IS [NOT] TRUE(expression int32) → boolean

• expression: Input expression.

Examples

ISTRUE example

SELECT ISTRUE(0)
-- False

IS [NOT] TRUE(expression int64) → boolean

• expression: Input expression.

Examples

ISNOTTRUE example

SELECT ISNOTTRUE(1)
-- False

IS [NOT] TRUE(expression boolean) → boolean

• expression: Input expression.

Examples

ISNOTTRUE example

SELECT ISNOTTRUE(FALSE)
-- True

IS [NOT] TRUE(expression int32) → boolean

• expression: Input expression.

Examples

ISNOTTRUE example

SELECT ISNOTTRUE(0)
-- True