[RESOLVED] How to find other zipcodes within certain miles with lat/lng?

Hi everyone,

I have a zipcode database in mssql which has the zipcode, lat and long. I need to write a query in my asp.net using vb.net to show all records with a zipcode within a certain number of miles.

I have seen calculations to show the distance between two zipcodes but I need to find the ones within say 10 miles or 25 miles.

Has anyone done this before?

Thanks!

Warren

I found the answer on a website:

http://blogs.lessthandot.com/index.p...e-longitude-pr

I loaded the functions in and the query with my existing table of zipcodes and it worked perfect!

Nice find! Thanks for sharing the link!

Gary