Posted by imani_technology_spam@yahoo.com on 10/25/05 00:36

Thanks!

Hugo Kornelis wrote:
> On 24 Oct 2005 11:43:32 -0700, SQL wrote:
>
> >use replace
> >update table set field = replace(field,',','') --commas
> >update table set field = replace(field,'.','') -- dots
> >update table set field = replace(field,'''','') --apostrophes
>
> Hi SQL,
>
> More efficient to do it all in one pass:
>
> UPDATE table
> SET field = REPLACE(REPLACE(REPLACE(field,',',''),'.',''),'''','')
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)

• Next in forum: Re: excluding fields in SELECT statement
• Prev in forum: Re: excluding fields in SELECT statement
• Thread view: Re: Stripping Punctuation

[Reply to this message]