Generating Sequence with aplhanumeric data
Hello All,
We have requirement to generate query to provide alphanumeric data in sequence. If I provide AA001 as parameter to query, it should give AA002. If It is AA999 then it should give AB001. If it is AZ999 the it should give BA001. If ZZ999 then it should throw error.
Please let me know if anybody has something similar.
Cheers,
Sandip