How do I store spatial coordinates in SQL Server 2005 I'm looking to store GPS co-ordinates in an SQL Server 2005 for location matching of users with GPS-enabled mobile phones. I've read about STDistance on MSDN, but it only appears to exist in SQL Server 2008 (&amp; later) along with the geometry and geography field types. I'll need to support older versions of SQL Server as well (at least 2005). 

What's the best way of storing GPS co-ordinates and calculating distances between 2 GPS locations in SQL Server 2005?
GPS co-ordinates are just latitude and longitude - if you have to support SQL 2005, then store them as numbers to your required precision.

To calculate the distance, you can implement the Haversine formula