Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Smart Quotes and ascii characters (http://www.go4expert.com/forums/smart-quotes-ascii-characters-t1181/)

daiondoroga 12Aug2006 19:57

Smart Quotes and ascii characters
 
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 13Aug2006 08:30

Re: Smart Quotes and ascii characters
 
Use the ASCII function. something like
Code: SQL

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



All times are GMT +5.5. The time now is 22:32.