I prepared a data base that has a simple - replace with serial number script. I wrongly assumed that all the serial numbers would be numbers so I created a number field for the Serial Number.
Then, I'm told that the Serial Numbers will contain a letter and a number.
When I insert A100000 as a variable and tell it to create serial numbers with this starting variable, the A gets dropped. The next number is just 100001. How can I make it keep the A?