|
|
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)
Navigation:
[Reply to this message]
|