Check
Re: How to find the missing number by sql Message #
687782 and
Re: Coding puzzle 3 Thread #
665235 ,
>I wish to find out all skipped number in a sequence range of numbers.
>For example: number range from 1 to 100, if 16 and 79 is absent, then
>16 and 79 are the outcomes. If this can be done by just one or two SQL
>statements, that's good function. Is there any built-in function inside
>VFP? Can you help?
>Thanks a lot.
--sb--