Search and replace the special chracters

Database
Enthusiast

Search and replace the special chracters

Hi,

I have a table with one single column(LATIN character set). I got a requirement to search and replace the following special characters with blank value in that column.

0xFFFE
0xFFFF
Control characters 0x0 - 0x19, except the following characters, which are legal: 0x9, 0xA, 0xD,tab, newline, and carriage return)
0xD800 - 0xDFFF

sample code will be a great help to me.

Thanks
Rahul