Posted by Hugo Kornelis on 10/24/05 22:25

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)

[Back to original message]