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