| Server IP : 104.21.13.164 / Your IP : 216.73.216.72 Web Server : Apache System : Linux gator4057.hostgator.com 5.14.0-687.17.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Jun 22 07:21:26 EDT 2026 x86_64 User : badawi ( 1130) PHP Version : 8.3.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/firebird/sql.extensions/ |
Upload File : |
--------------------
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 <[email protected]>
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