Control Characters in column

Greetings all.
Problem: Have control characters mostly ^B which are loaded into a table in our database forming part or a narative field. In TOAD these appear as a thick bar - kind of like a pipe character '|' but thicker. We need to get rid of these as they are causing problems with our information exchange software. Does anybody have any idea how to do a search and replace for such characters in an oracle 9i database? The table has over 60M record so I dont facy checking it manually as I recon Ill be 84 years old by the time im finished! Thanks. Received on Thu Feb 26 2004 - 14:28:48 CET