The Geography data type is used in many different SQL Server databases. It contains Latitude, Longitude, and many other properties and functions.
In this video I show you how to extract the latitude and longitude from the Geography data type.
Video: Latitude and Longitude with the Geography Data Type
How to extract the latitude and longitude from the Geography data type..
I use the Wide World Importers and the following scripts:
--SQL Geography Data Type select CityName ,Location.Lat Latitude ,Location.Long Longitude ,cast(location as varchar(max)) from Application.Cities
Link to the a good tutorial on MSSQLTips.com.
See the original Latitude and Longitude in SQL Server video.