Teknoids

I have a MS Sql table with about 3600 records, one field of which is
"FHFL," which is a case number. I am trying to figure out which case
numbers in a given range are missing. Is there a make-table query that
will return a list of numbers that are missing in a given range of
numbers? The numbers are 5-digit numbers like 15001, 15002, etc., but
the field type is text.

I can certainly copy the table and change the field type to numeric if
that will help, but I'm a real noob when it comes to queries. I usually
view and edit the records in Access, but I also have access to Sql
Enterprise Manager.

Thanks!

Tracey