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;