wonder if anyone can help.
I have a field with an automatically generated number.. 001, 002, 003 etc...
How can i get another field to take that number and remove the zeros?
e.g 012 would be 12, 006 would be 6, 123 would be 123.
Any help, (as always) would be appreciated.