random to fix length

M

mike

I have field [inv_no and is numbered from 1 to 999999. I would like the
numbers to be from 000001 to 999999 (all fields with six numbers). Any
suggestions? Thanks.
 
Top