[daiondoroga]

Hi!
I need to update a VARCHAR2 column in a database and replace all occurances of a particular ascii character with another ascii character. These are not visible in the text as it's stored in the column. What functions can I use to do this type of replacement?

[shabbir]

Use the ASCII function. something like

UPDATE table-name SET column-name = ASCII('A') WHERE column-name = ASCII('B')