How do I select Lat & Long coordinates back out of SQL Server Geography data type field

Select convert(varchar(max),Coordinates) as Coordinates from SpatialZonePolygons ;

take a look here for more information - SQL Server Geography Data Type

You may use something like this(SQL SERVER)

SELECT Coordinates.Lat 'Latitude', Coordinates.Long 'Longitude' FROM SpatialZonePolygons 

For more information - How To Get Lat-Long From Geography Data Type