# Thread: Decimal to ASCII conversion

1. Registered User
Join Date
Aug 2003
Posts
2

## Unanswered: Decimal to ASCII conversion

I need to convert a decimal number to 2 ASCII characters using SQL. For example, 13110 (16 bit word which is 2 bytes) would be a decimal value representing 36 in ASCII.
Any ideas?

2. Registered User
Join Date
Aug 2003
Location
Delft, The Netherlands (EU)
Posts
447

## Re: Decimal to ASCII conversion

I don't get the transformation fomula.

You get 36, I suppose the characters '3'+'6'. '3' has the ASCII value 51 (decimal) and '6' has the value 54 (decimal). I do not understand how 51 and 54 can be derivated from 13110. Can you help me?

3. Registered User
Join Date
Aug 2003
Location
Delft, The Netherlands (EU)
Posts
447

## Re: Decimal to ASCII conversion

I'm sorry, actually it's quite straight forward: 51 is the one word, and 54 is the other word, and together they form your 13110 (decimal) or better to see 3134 (hex).

Anyway, the code is:
SELECT char(floor(13110/256)), char(13110-floor(13110/256)*256)

Cheers!

4. Registered User
Join Date
Aug 2003
Posts
2

## You are a lifesaver Doc

That worked! You the Man! Thanks Bunches!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•