Hi everybody,
It is a simple thing but i don't get answer for that.
I am generated auto generation id concatenate with year 100001, 100002 like that, in this 10 is year 0001 is auto generation numbers. When i split the year and number then getting add one value is 2 for 0001. but i need as 0002.
Adding value is 0001+1, 0002+1, 0010+1, 0099+1
Now the answer are 2, 3, 11, 100 like that
But i need like that 0002,0003,0011,0100
Thanks in advance.