I would like to ask for your opinions which would be the fastest way to find the first available gap. The situation is the following:
There is a column char(8). The last 2 chars can contain 0,1,...A, B....,Z.
So if we see the last 2 chars then they look like something like this:
Should have to find the first gap, for instance in case of:
The first available gap would be A9
In case of:
The first available gap would be 04
Let's suppose that the records are ordered by the last 2 chars as a starting point. I am thinking about which way would be the fastest way to find the first gap