Add Leading Zeros to ZIP

Description

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 Command After Command
Before running the command
After running the command

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.