Kory -
It's always a little more challenging to find something that's NOT in the data!
I'd suggest two approaches:
1 - create a reference table containing all the possible values, 1 -
999. Then do a SELECT MIN and a join to find the lowest number
not in your data table, something like this
Would it be practical to leave the record in the table and mark it as
unused? That would certainly simplify the whole business.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: