Re: Restore Leading Zeros in Zip Codes
| From: | Afan Pasalic | Date: | Fri, 22 Aug 2008 16:28:38 +0000 |
| Subject: | Re: Restore Leading Zeros in Zip Codes | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-278531@lists.php.net to get a copy of this message | ||
tedd wrote:
At 8:44 PM -0600 8/21/08, Keith Spiller wrote:-afanHi, RE: Restore Leading Zeros in Zip Codes Does anyone happen to have a script that will restore the leading zeros in a mixed data set of 5 digit zip codes and 10 digit zip+4 codes? Any suggestions? Thanks, KeithKeith: Why take them out in the first place? Keep the zip code as a string. After all, not all countries use just numbers. Cheers, tedd or, if you use US zip codes only, use ZEROFILL feature in mysql?