Remove spaces from field in VBA?

H

Harmannus

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
 
D

Dale Fye

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

HTH
Dale
 
Top