>Hi Al,
>
>Thanks. I do not know what I was/am thinking. My brain is completely burned, I am not sure if you are looking the same thing as I am, as I am looking it now, my method will never work for the question asked, it will give just the first numbers missing in the sequence, but if there is a range missing then it fails, is that what you were pointing me?
>
>>Hi Hugo,
>>
>>Your technique is very clever but I think it doesn't always work. In your sample code, check what happens if you INSERT the value 8 instead of 7, when creating your test cursor :(
Yes, basically that's it. But, I happened to be testing with a sequence # - missing - # - missing, and that's where I first noticed it. It actually shows up in your own example - for any gap greater than one number, it shows only the last member of that gap.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up