Re: [ic] Increment integer with preceding zeros

[JT Justman <suppressed>]

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.

Not sure if MySQL has a function for this. Using auto increment is 
better if this is an index.

In Perl you can use sprintf:

sprintf("%06d", $i);

Where 6 is the desired width.

-- 
JT Justman
End Point Corporation
http://www.endpoint.com/

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users