Firebird 1.0: the *NVL
functions
Firebird 1.0 doesn’t have COALESCE
.However, you can use four UDFs that provide a good part of its functionality.These UDFs reside in the fbudf
lib and they are:
-
iNVL
, for integer arguments -
i64NVL
, for bigint arguments -
dNVL
, for double precision arguments -
sNVL
, for strings
The *NVL
functions take exactly two arguments.Like COALESCE
, they return the first argument if it’s not NULL
;otherwise, they return the second.Please note that the Firebird 1.0 fbudf
lib — and therefore, the *NVL
function set — is only available for Windows.