Support 805.461.7300
Sales
Our Technology. Your Success.

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 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.

« Back to Commands

AccuZIP's customer service is great. It keeps us from having down time and I'm always able to get a quick answer. don't have to worry about the size of the order I'm working with a client on. Most times, AccuZIP employees know more than the USPS employees. I've been able to navigate the lack of government employee training, which saves time, money and headaches.
M.L., Lansing, WV