Removing all occurrences of Untranslatable Character

Database
Enthusiast

Removing all occurrences of Untranslatable Character

I am using the following query to find out columns that have untransalatable characters:

SEL msg,

translate_chk (  msg using LATIN_TO_UNICODE) as pos 

FROM Msgtbl WHERE pos<>0;

I am finding the initial position of the untranslatable character.

I want to remove all occurences of the untranslatable characters in the msg string.How can I do  this?