Saludos.
Extraído del Firebird 2.0.1 Release Notes.
Cita:
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.
__________________
Gracias,
Rolphy Reyes
|