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.