Remove spaces from field in VBA?

Harmannus · Jul 16, 2004

Hallo,

How can i remove a space(s) from a field in VBA e.g. a zipcode: 9999 ZZ to
9999ZZ

Thanx for any help!

Regards,
Harmannus

Dale Fye · Jul 16, 2004

Update your ZipCode
SET ZipCode = REPLACE([ZipCode], " ", "")
FROM yourTable

HTH
Dale