i use varchar(10) for mine that way the starting 0 is not knocked off but it also allows for 00000-0000 format zips -- Joseph Crawford Jr. Codebowl Solutions codebowl@xxxxxxxxx 802-558-5247 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php