punctuation in between characters

[ddtpmyra]

I have address field and the data has puctuations like comma and periods. How can I update the data and delete the punctuation.

I'm not sure if this works but I post here before commiting error.

update table_address set address ='% %' where address like '%.%'

[NeoPa]

I can only think of developing a User-Defined Function (udfStrip) that does the basic work for you and use it in an UPDATE query like :

UPDATE [Table_Address]
SET    [Address] = udfStrip([Address])
WHERE  ([Address] LIKE '%.%')
   OR  ([Address] LIKE '%,%')

I tried to think of a way to use RegExes but couldn't find a way :-(