Fill every character position when creating the initial value of an auto-increment field. This maximizes the number of unique records that can be created. Auto-Increment Tip by Tom Cone Jr. Full Story