Convert to Hex

[Sarel j Smit]

If I do a query from SQL 7.0 and get the result "10" which is a hex value
(0x0A), how do I convert this using something like convert or cast to show
"a"
Is there anywhere that I can look for help? I can get it to show 0x0A using
cast, but that is not what I want. I want a hex number without 0X0 in front
of A. The A I can convert using something like Lower(A)

Thank you.

[Adelle Hartley]

"Sarel j Smit" <ssmit@news24.co.za> wrote in message
news:3b0cb305$1@news.devx.com...
>
> If I do a query from SQL 7.0 and get the result "10" which is a hex value
> (0x0A), how do I convert this using something like convert or cast to show
> "a"
> Is there anywhere that I can look for help? I can get it to show 0x0A
using
> cast, but that is not what I want. I want a hex number without 0X0 in
front
> of A. The A I can convert using something like Lower(A)

How about something like

Lower(Right(Your_Cast_Expression,LEN(Your_Cast_Expression)-3)))

Adelle.
_____________________________________________________________
Impress your friends. Become an SQL guru.
http://www.sql-guru.com