MOON
Server: Apache
System: Linux kvm.asjudinet.com 5.14.0-611.54.6.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Fri May 15 04:23:18 EDT 2026 x86_64
User: asjudine (1001)
PHP: 8.0.30
Disabled: exec,passthru,shell_exec,system
Upload Files
File: //usr/share/doc/firebird/sql.extensions/README.iif
--------------------
IIF builtin function
--------------------

Function:
    Return a value of the first sub-expression if the given search condition
    evaluates to TRUE, otherwise return a value of the second sub-expression.

Author:
    Oleg Loa <loa@mail.ru>

Format:
    IIF ( <search condition>, <value expression>, <value expression> )

Syntax Rule(s):
    IIF (SC, V1, V2) is equivalent to the following <case specification>:
         CASE WHEN SC THEN V1 ELSE V2 END

Example(s):
    SELECT IIF(VAL > 0, VAL, -VAL) FROM OPERATION