Use Zip Code long and lat to restrict sales area

[Timothy.Rybak]

Hello,

I have an extracted list of US zip codes and their longitude and
latitude. I want to use this data to restrict the sales area of a
product. For example, say I have a store with a certain product line
in zip code 12345. A different store from zip 12347 calls and wants to
sell this product line. I want to be able to use a query to check
whether there is any dealer within, say, a 25 mile radius of 12347 that
stocks that product line.

Any ideas of where to start?

Z

 

[Guest]

I'd look into Microsoft Map Point before reinventing the wheel:
http://www.microsoft.com/mappoint/default.mspx