meta data for this page
  •  

F_DNVL2

function from adhoc

Entrypoint dnvl2 compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE     value to check if NULL
              DOUBLE     return instead of NULL
              DOUBLE     return instead of param 1
   Output     DOUBLE     value

Syntax

   version for double precision with set value for not NULL
   All Functions like Oracle-NVL-functions.
   TestSQL
   SELECT 'is NULL' AS ISCORRECT, F_SNVL(NULL, 'is NULL') FROM RDB$DATABASE;
   SELECT 'this is not NULL' AS ISCORRECT, F_SNVL('this is not NULL', 'is NULL') FROM RDB$DATABASE;
   SELECT 'is NULL' AS ISCORRECT, F_SNVL2(NULL, 'not NULL', 'is NULL') FROM RDB$DATABASE;
   SELECT 'not NULL' AS ISCORRECT, F_SNVL2('this is not NULL', 'not NULL', 'is NULL') FROM RDB$DATABASE;
   SELECT 9999 AS ISCORRECT, F_INVL(NULL, 9999) FROM RDB$DATABASE;
   SELECT 3 AS ISCORRECT, F_INVL(3, 999) FROM RDB$DATABASE;
   SELECT 9999 AS ISCORRECT, F_INVL2(NULL, 999, 9999) FROM RDB$DATABASE;
   SELECT 123 AS ISCORRECT, F_INVL2(3, 123, 9999) FROM RDB$DATABASE;
   SELECT 0.0001 AS ISCORRECT, F_DNVL(NULL, 0.0001) FROM RDB$DATABASE;
   SELECT 3.0 AS ISCORRECT, F_DNVL(3.0, 0.0001) FROM RDB$DATABASE;
   SELECT 0.0001 AS ISCORRECT, F_DNVL2(NULL, 3.333, 0.0001) FROM RDB$DATABASE;
   SELECT 3.333 AS ISCORRECT, F_DNVL2(3.0, 3.333, 0.0001) FROM RDB$DATABASE;