Remove single quote from column value in oracle sql

Question

Guys, I want the following sql oracle query to print the following value. I want to remove a single quote from a column value. Let me know how to do it

select MSGID from schemaname_interface_daily_20110427 ; 

Input:

 X'414d51204545415837313150202020204d54a9e423d31a16' 

Output:

 X414d51204545415837313150202020204d54a9e423d31a16 

Answer 1

 select replace (MSGID, '''', '') from schemaname_interface_daily_20110427; 

Complete REPLACE function documentation .