Hexadecimal to integer conversion

Analytics
N/A

Hexadecimal to integer conversion

Hellooo , i have a table "table1" with one field named "field1" where it contains hex values .

i want to convert the values in this field to integer by one query :

select function(field1) from table1

possible values for example  : 'B52B' ,'DBC0' ,'963B'