[ic] Increment integer with preceding zeros

[Peter]

On 04/05/2008 07:05 PM, Grant wrote:
> Is there a way to increment an integer like 000001 to end up with
> 000002?  The integer is stored in a MySQL table.


Of course, there's a few different ways.  If you give some more details 
of what you're trying to do, though, it will be easier to give an 
appropriate answer to your question.  Where do you want the increment to 
occur, and when, etc?

Peter