extract latitude from dbgeography in sql query [closed]

Question

i have a dbgeography column in sql server which stores latitude and longitude information. I want to extract latitude or longitude information using sql query but i couldn't find a way to do so. How could it be done?

No C# code.

Answer 1

Does something like this work?

select Location.Lat, Location.Long from GeographyTable