Hi all,
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
Visual FoxPro? Can you help?
Thanks a lot.
Want you all skipped number or all skipped range ?
Example:
Sequence Domain : 1..10
Sequence : 2,3,6,7
all skipped number : 1,4,5,8,9,10
all skipped range : 1:1,4:5,8:10