Newbie question, here.
I have a database that frequently imports ZIP code data that
frequently needs cleaning:
12365
6487
64684-3543
3213-6546
I.e. missing leading zeroes, five digit vs nine digit ZIPs, etc.
How would I format the "Update To" command to: 1) restore leading
zeroes to four and eight digit zips and 2) standardize all ZIPs to
five digits??
Thanks!