> > I'm looking into the ZEROFILL option now. Didn't know about > it before but it > looks promising and probably is my solution. I'll get back. Obviously, with a 4 digit id, you will only be able to store 10,000 records. If I recall correctly, MySQL auto-increment fields will not reuse id's when they are deleted. So, you will need to take that into consideration when (if) you reach the 9,999th record. JM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php