http://www.meridianworlddata.com/Distance-Calculation.asp
A UDF for doing the calculation http://cflib.org/udf.cfm?ID=502
--
Howard Fore, [EMAIL PROTECTED]
"I hope you believe you understand what you think I said, but I'm not
sure you understand that what you've heard is not what I meant."
President Richard Nixon
On Mar 19, 2004, at 2:00 PM, Scott Weikert wrote:
>> How do I perform a radius search based on zip code?
>>
>> For instance, suppose I have a database of graphic artists. How do
>> I
>> find all "graphic artists" within a 20 mile radius of the given zip
>> code. Is there a service that provides such information? Is
>> something
>> like that even possible with just zip code?
>
> There's zip code databases out there that have latitude/longitude
> data, and
> then there's some algorithm (I don't have it here) that you can feed
> it two
> lat/long pairs and it will tell you the mileage between, as the crow
> flies.
> Can't just do it with zip codes by themselves, you need locational
> data.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
