CREATE CURSOR sequence (nval n(3,0)) INSERT INTO sequence VALUES (1) INSERT INTO sequence VALUES (2) INSERT INTO sequence VALUES (4) INSERT INTO sequence VALUES (5) INSERT INTO sequence VALUES (6) INSERT INTO sequence VALUES (9) INSERT INTO sequence VALUES (11) INSERT INTO sequence VALUES (12) INSERT INTO sequence VALUES (15) SELECT x.nval+1 gapstart, MIN(y.nval)-1 AS gapend ; FROM sequence x, sequence y ; WHERE x.nval < y.nval ; GROUP BY x.nval ; HAVING gapend - x.nval >= 1