title: How do I select Lat & Long coordinates back out of SQL Server Geography data type field
body: <p>Considering the SQL Server 'geography' data type...</p>
  
  <p>I can enter an array of latitude and longitude (btw is that the correct order to do so or should it be longitude latitude?) points into the field as follows:</p>
  
  <pre><code>INSERT INTO SpatialZonePolygons (Coordinates)
  VALUES (geography::STGeomFromText('POLYGON((-122.358 47.653 , -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326));
  GO
  </code></pre>
  
  <p>This then appears as: </p>
  
  <pre><code>0xE6100000010405000000DD24068195D34740F4FDD478E9965EC0508D976E12D3474083C0CAA145965EC04E62105839D4474083C0CAA145965EC04E62105839D44740F4FDD478E9965EC0DD24068195D34740F4FDD478E9965EC001000000020000000001000000FFFFFFFF0000000003
  </code></pre>
  
  <p>How do I select them back into their latitude and longitude formats?</p>