I am using one Stored Procedure to Find a NextNumber of my ItemId
It has some errors sometimes it is working.
So Item Code may be like 'It0001' or '25344' or 0144BA'

So Howto findout the Next Itemcode.
Suppose the if user enter the code like 1,2,.... 10. After 10 it
has to display 11. If I have 1,2..A. Then it has to show A1

my question is to find a nextID for Character Datatype values.

If any one has code please give me that will help me a lot.