help with removing Punctuation

[analytics2006]

How can I remove Punctuation
from the address field like listed below?

555 S. 3829 W.#

 

[gmmastros]

Use the replace function.

Select Replace('555 S. 3829 W.#', '.', '')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

use replace, example

create table blah222(Address varchar(666))
insert blah222 values('555 S. 3829 W.#')


select *,'before' from blah222

update blah222
set Address = replace(Address,'.','')

select *,'after' from blah222

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions