recycling numbers from db

Hello,

I have to get a value that is not in a table, how can I do this? The purpose is to recycle numbers, e.g.:

table content:

1
3
4
5
7
9
10

I want the first number that is not in, thus I want 2 as result. Is this possible?

Thanks in advance,

Dominick Received on Wed May 10 2000 - 00:00:00 CDT