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: dkasak@stripped
website: http://www.nusconsulting.com.au
