If I have a column with a list of numbers between 1 and 9999 is there a
way to select all the numbers in that range that have not been used?
For example lets say the list is 1 - 10 instead, and looked like this.
1
2
3
5
7
9
10
I want the database to return
4
6
8
Any hints or ideas?
--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
cd /pub
more beer