Entrypoint hextoint
Input CSTRING(20) Hexword Output INTEGER integer in decimal system
TestSQL SELECT 13 AS ISCORRECT, F_HEXTOINT('000000000d') FROM RDB$DATABASE; SELECT 13 AS ISCORRECT, F_HEXTOINT('d') FROM RDB$DATABASE; SELECT 13 AS ISCORRECT, F_HEXTOINT('D') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_HEXTOINT(NULL) FROM RDB$DATABASE;