MySQL Forums
Forum List  »  Newbie

Displaying
Posted by: Noel Colleran
Date: March 28, 2005 07:51AM

Hi, I have a field value ClientNo. This will auto-increment every time a client added to the system. The auto-increment works fine. The problem that I have, is that instead of displaying the a ClientNo as 2, I would like it to display as 000002. With the extra zeros as padding. Is it possible to assign the zero value with all those added zeros from the beginning?

Options: ReplyQuote


Subject
Written By
Posted
Displaying
March 28, 2005 07:51AM
March 28, 2005 08:22PM
March 28, 2005 10:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.