[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
Re: How to find other zipcodes within certain miles with lat/lng?
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!
Re: [RESOLVED] How to find other zipcodes within certain miles with lat/lng?
Nice find! Thanks for sharing the link!
Gary