Thank but only one value inserting in a table it's not incremented.

example in table only aa001 only displaying it should be incremented till aa999 na.

thank you:-)

I need logic for generating following pattern.

AA001A0 TO AA999A0 THIS IS FIRST SCENARIO.

NEXT IS AA001B0 TO AA999B0 IS SECOND SCENARIO.