instrucción iif en vista Firebird

[RolphyReyes]

Saludos.

Extraído del Firebird 2.0.1 Release Notes.

IIF Expression Syntax Added
O. Loa
IIF (<search_condition>, <value1>, <value2>)
is implemented as a shortcut for
CASE
WHEN <search_condition> THEN <value1>
ELSE <value2>
END
It returns the value of the first sub-expression if the given search condition evaluates to TRUE, otherwise it
returns a value of the second sub-expression.
Example
SELECT IIF(VAL > 0, VAL, -VAL) FROM OPERATION

Espero te sirva.