Conversion from Hexadecimal to Char

Database
Enthusiast

Conversion from Hexadecimal to Char

Hi All,

Can someone please help me how to convert a Hemxadecimal value from a column.

HexValue_of_Col            

----------------------

5050

4040

I am aware we can convert a single value for eg:  Select (X'5050') which gives PP.But I want Convert all the values in a column.Select (X'HexValue_of_Col') does nt work.Can some one help me with this please ?

Thanks,

Ashok.