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?
Use the ASCII function. something like Code: UPDATE table-name SET column-name = ASCII('A') WHERE column-name = ASCII('B')