I am 100% sure it would not go beyond C usually,with 3 exemptions if all are utilized it will go F. SO we do not have to think until Z.

One way I made it work is like this--

Right at the end just before I insert into the main db table, I added an identity column to the table...

We don't get to Z. At the most we can reach E or F.

100025730543909587546810958754681A

100025730543939587546810958754681B

100025730543999587546810958754681C

So this is the problem - When there is a change in the EdgNumber I need to increment the alpha identifier.. it works well when there is a record already...

No. It is a part in the stored procedure. I cannot put triggers.

Basically I could have used identity but there isn't an identity column. So it boils down...