Posted by SQL on 10/24/05 21:43

use replace
update table set field = replace(field,',','') --commas
update table set field = replace(field,'.','') -- dots
update table set field = replace(field,'''','') --apostrophes
you can put this in a trigger if you want to do this automatically

------------------------------------------------------------------------------------------
"I sense many useless updates in you... Useless updates lead to
defragmentation... Defragmentation leads to downtime...Downtime leads
to suffering..Defragmentation is the path to the darkside.. DBCC
INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with
you" --
http://sqlservercode.blogspot.com/

[Back to original message]