IF-THEN-ELSE

The IF-THEN-ELSE statement provides an alternative syntax to the CASE statement.

IF <logical expression> THEN
<arithmetic expression>
[ELSE <arithmetic expression>]
END

Byte

SELECT boolean1,
IF boolean1 = true
THEN 'Yay, it''s TRUE!!!'
ELSE 'Oh no! FALSE!!'
END
FROM AllTypes();