Add Leading Zeros to ZIP
This command will add leading zeros to the ZIP field for all the ZIP codes that are supposed to begin with a zero or a series of zeros. The ZIP codes that are already a width of five and do not need a leading zero will not be affected.
The Command At Work
|Before running the command||After running the command|
Copy this command, then paste it into the large text area of the command window:
REPLACE zip WITH PADL(ALLTRIM(zip),5,"0") FOR LEN(ALLT(zip))<5
After clicking RUN, the ZIP field will add leading zeros to the beginning of the number until the ZIP Code is a width of five characters.