Convert from Hexadecimal value to Ascii ?

[PRIT AMRIT]

Hi guru's,

Is it feasible to convert from Hexadecimal value to Ascii?

E.g.636174 =cat

http://www.string-functions.com/hex-string.aspx

Thanks
Prit

[Rutulian]

Hi Prit,

You could get the ASCII list from somewhere like http://www.ascii.cl/ and use it as a lookup table.  Seems like something that might better be done by type conversion at an earlier stage though - if you have hex values that you know are ascii characters, why not just deal with them as a kind of varchar?