calculate distance

[Guest]

Hi,i want to give aa zipcode and find the distance between 2 zipcodes do you have any idea?its better i
I can find some thing free but not necessar
tanck you

 

[Dan Brussee]

Google "great circle distance zip formula". I have the calculation set
up in a user defined function in SQL Server, which has been very
helpful in pulling things like a list of classes local to a user. I
also have a complete list of 42000 plus zip codes, states, counties,
etc gleaned for free off several public sites.