sql to find a numeric range inside another range?

hi,

i'm building a query to find narrow ranges of zip codes within broader ranges in a table (for tax purposes). for example:

LOW_ZIP HI_ZIP
23400 23499

need to find

23401      23402
23403      23440
23441      23... you get the picture. :)

so, each row has a low value and a hi value, then i need to run a subquery to take those values and find narrower ranges. any ideas? Received on Tue Mar 02 2004 - 16:34:49 CST