Zip Code Function in SQL Server

[westmich]

This post relates to this one on zip code proximity - http://www.sitepoint.com/forums/showthread.php?t=157759

I was able to get this working correctly so that a user can plug in a zip code and a radius and see all the zip codes that fall in the radius. But what I would love to have is a custom function that when I run the query I also get the distance between the zip code I am looking up and the ones it returns.

Select Zipcode, ZipDistance('49415') as Distance
From Zipcodes
Where Latitude = 'somenumber' And Longitude = 'somenumber'
Order By Distance

The Where clause I know ho to do - it's the function I've been beating my head against the wall on.

[MarcusJT]

Since each ZIP has a longitude and latitude, surely what you're really asking is how to calculate the distance between two points on the surface of a spheroid?

[fillup07]

And that's not difficult at all...

[ashattuc]

I was wondering, Westmich, how did you get your list of zip codes with lattitude / longitude coordanants? I have been looking for them, but have been unable to find anything.

Thanks,
Chris S.