Ashley M. Kirchner wrote:
Is there a way to automatically pad a query result? For example: select id, user from table +-----+--------------+ | id | user | +-----+--------------+ | 3 | Tinker Bell | | 11 | Peter Pan | | 7 | Dumbo | | 121 | Mickey Mouse | +-----+--------------+ What I really want is: +-------+--------------+ | id | user | +-------+--------------+ | 10003 | Tinker Bell | | 10011 | Peter Pan | | 10007 | Dumbo | | 10121 | Mickey Mouse | +-------+--------------+
Ah, and I also just remembered, there is a ZEROFILL attribute for numeric types. Details at http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]