m i l e s wrote:
Hi,
I have an odd situation where I was handed just bad data, and while I
have cleaned it up to the best of my ability one hurdle remains.
I have a situation where I have the following example in a field:
Canna ÒBengalÒ.
Note the odd chrs "Ò" in the field ? I need to get rid of those, my
question is HOW.
And I have thousands of rows like this and its just ONE field that's
the stumbling block.
Any suggestions ?
M i l e s.
replace()
eg:
update some_table set some_field = replace( my_field, "Ò", "O" );
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au