create cursor c_test (value I) insert into c_test values (2) insert into c_test values (3) insert into c_test values (4) insert into c_test values (6) insert into c_test values (7) insert into c_test values (12) insert into c_test values (13) insert into c_test values (14) insert into c_test values (16) insert into c_test values (17) select value-1 as value ; from c_test ; where value not in (select value+1 from c_test) and value-1 > 0 ; into cursor c_resultIf you are only interested in the first missing number, then you can add:
order by value ; top 1or for the last one:
order by value descending; top 1