List:General Discussion« Previous MessageNext Message »
From:Daniel Kasak Date:September 23 2005 5:30am
Subject:Re: SQL help: Updating Strange Chrs.
View as plain text  
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

Thread
SQL help: Updating Strange Chrs.m i l e s23 Sep
  • Re: SQL help: Updating Strange Chrs.Daniel Kasak23 Sep