Re: Convert hex to decimal?

[Dušan Pavlica]

Frederic Wenzel napsal(a):
> Hey,
>
> I have a table with a SMALLINT column that -- trough a mistake --
> contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e.
> HEX numbers).
>
> How would I convert
>
> 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)?
>
> I tried my luck with UNHEX and CAST but I only got 0 or NULL back 
> respectively.
>
>
> Thanks in advance
> Fred
>
conv('column_name', 16, 10)

Dusan