0 - 3 of 3 tags for hexadecimal

Greetings Experts,
Can convert char to hexadecimal using char2hexint function.  When the column used in unicode or latin it becomes as 

Hi,
I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query.
SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),'base16'),'base10') AS INT)) AS col_A_dec FROM table_a

Hi,
I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query.
SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),'base16'),'base10') AS INT)) AS col_A_dec FROM table_a