Remove spaces in a column

[kbaisch]

I have a column in a table in an SQL server that has unwanted spaces. I have tried this code and it doesn't work.

UPDATE Petersburg_ SET Residence_ = REPLACE(Residence_,',',',');

Column data looks like this:
AKIAK, AK
PETERSBURG,AK

I don't want any spaces in front, between or end.

Can someone help me? Please?

[iburyak]

Try this:

[PHP]UPDATE Petersburg_ SET Residence_ = REPLACE(Residence_,' ','')[/PHP]

[kbaisch]

Try this:

[PHP]UPDATE Petersburg_ SET Residence_ = REPLACE(Residence_,' ','')[/PHP]

It WORKS!! I can't thank you enough!

[iburyak]

No problem that was easy.... :)