m i l e s wrote:
> 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.
update some_table set some_field = replace( my_field, "Ò", "O" );
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989