if you want 000447 and not 444760, maybe you should pad UPC's with less than 6 numbers with zeros?
Meaning how are UPC coded with what characters?
Thanks for your help in the past, it was greatly appreciated. I have another issue that i thought you maybe able to help with.
Each record within our database contains a code, these codes contain 3-11 integers and represent grocery product UPC codes. I need to add zero's to the beginning of each record now so they will have the minimum 7 integers. Do you know of an easy way to doing this in FileMaker Pro 13? I'd like to pad multiple records at once.