Padding out the serial number?

[jdenver]

Ive been using Filemaker for a number of years and when I created the database, I set the customers number to be auto created as a serial number incremented by 1 each time a record was created. I now have 3000 customers that starts with 1, 2, 3, 4, - 3000. Is there away to modifier the existing numbers so as customer 1 is now 0001 and 2 is now 0002 etc.

[Kilyaaan]

You should be able to use

Replace Field Contents [ table::customerNumber ; Right ( "0000" & table::customerNumber ; 4 ) ]

If you are using the customerNumber in relations it should still be working ( at least it does in FM 11 )

[jdenver]

Thanks Kilyaaan, just what i was looking for