Re: Convert Char to Hex (EBCDIC)

[Udhayakumar Sankaran]

Hi Peter,
Thank for your response. I had posted a reply last week but not sure why it was not there.

Select hex("ABCDE"); --> 4142434445
Whereas I am expecting result as C1C2C3C4C5

Just to brief my requirement: I want to convert CHAR to EBCDIC binary format (ex: "ABCDE" to be converted to "1100000111000010110000111100010011000101")

Upon analysing a bit found that I need to follow two step to achive this
1. Convert CHAR to Hex EBCDIC (ABCDE -> C1C2C3C4C5)
2. Convert Hex to Binary (C1C2C3C4C5 -> 1100000111000010110000111100010011000101)

Got the below function to perform#2 , but unable to get function to perform#1
Select LPAD(CONV('C1C2C3C4C5', 16, 2), LENGTH('C1C2C3C4C5')*4, '0')