meta data for this page
  •  

F_INPUTVAL

function from adhoc

Entrypoint euroval compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE          floatingpoint
   Input      CSTRING(10)     currency sign
   Output     CSTRING(32)     floatingpoint (currency sign after the number) (rounded to 2 digits)

Syntax

   TestSQL
   SELECT '15.42 €' AS ISCORRECT, F_INPUTVAL(15.4249, '€') FROM RDB$DATABASE
   SELECT NULL AS ISCORRECT, F_INPUTVAL(NULL) FROM RDB$DATABASE;