Oracle
|
NVL2 (exp1, exp2, exp3)
|
NVL2 lets you determine the returned value depending on whether a specified expression is NULL or NOT NULL.
If exp1 is NULL value, then the value of exp2 is returned. If exp1 is not NULL, the value of exp3 is returned. The argument exp1 can have any data type.
If the data types of exp2 and exp3 are different, then Oracle converts exp3 to the data type of exp2 before comparing them unless exp3 is a NULL constant
The data type of the return value is always the same as the data type of exp2, unless exp2 is character data, in this case the returned value's data type is VARCHAR2.
|
Sybase Adaptive Server Anywhere
|
IFNULL (exp1, exp2 [,exp3])
|
IFNULL lets you determine the returned value depending on whether a specified expression is NULL or NOT NULL.
If exp1 is NULL value, then the value of exp2 is returned. If exp1 is not NULL, the value of exp3 is returned. If exp1 is not NULL and there is no exp3, NULL is returned.
|