Re: sql to find a numeric range inside another range?
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 2 Mar 2004 18:08:38 -0500
Message-ID: <ePydnbw8FsucidjdRVn-uA_at_comcast.com>
Date: Tue, 2 Mar 2004 18:08:38 -0500
Message-ID: <ePydnbw8FsucidjdRVn-uA_at_comcast.com>
"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 Wed Mar 03 2004 - 00:08:38 CET