So, lets say in our DB we are reading a column.
The column is a string (varchar). Example of values:

0.0.0.100-0
0.0.0.100-1
0.0.0.100-2
0.0.0.100-3
0.0.0.101-0
0.0.0.102-1
0.0.0.103-0


its like a "version" thing.

So, I need to know which one would be missing from the list. What I mean is:

0.0.0.100-0
0.0.0.100-1
0.0.0.100-3
0.0.0.100-4

in here, we know 0.0.0.100-2 so i need to "flag" this.

however, if all was fine, then it should also be able to handle this:

..
0.0.0.100-2
0.0.0.100-3
0.0.0.101-1
0.0.0.101-2

we know here that 0.0.0.101-0 is missing - it needs to flag this scenario too.

any ideas what the best way is?