Smart Quotes and ascii characters

daiondoroga's Avatar
Go4Expert Member
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?
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Use the ASCII function. something like
Code: SQL
UPDATE table-name SET column-name = ASCII('A') WHERE column-name = ASCII('B')