mirror of
https://github.com/FirebirdSQL/firebird.git
synced 2025-01-22 16:03:03 +01:00
21 lines
541 B
Plaintext
21 lines
541 B
Plaintext
|
--------------------
|
||
|
|
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
|