Is there anyway to pad an id field in MySQL? I have a table with a PK field (id). This field is auto incrementing a 6 digit number ie. 000223. Is there anyway to pad this id so that it is padded with a code along with the auto incrementing part, such as ABC000223. Now I wouldn't want the ABC pad to change but the 6 digits would still auto incr as required.
Is this possible without doing any field editing, exclusively with a MySQL utility? thanks /Merle -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]