>Is there a way to determine distance from a zip code?
>
>For example, we would like to point our customers to a dealer closest to them. We would like to have the customer enter in their zipcode and then we would like to display a list of dealers in their area, within 50 miles.
>
>Is there a calculation to use, such as: the first 3 digits of the zipcode will be a 50 mile radius and the first 4 digits will be a 25 mile radius and so on?
>
>Thanks,
>
>Jerry
Yes this is posible. We made this for a web-site which serve airlines agents.
They bought USA, Canada, Mexico, UK zipcodes DB with longitude and latitude and from them it is easy to calculate all agencies which come into this radius.
one of My coders wrote a SP which do this
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only