Re: sql to find a numeric range inside another range?

"dbarchitech" <noble_kid_at_mac.com> wrote in message news:9d3dc423.0403021434.18a3078e_at_posting.google.com...
| 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?

yeah, but you got to show us yours first ;-)

;-{ mcs Received on Tue Mar 02 2004 - 17:08:38 CST