title: SQL Query to return Geography type as XML
body: <p>I'm trying to return an XML from a table which holds a Geography type.<br>
  SQL query:  </p>
  
  <pre><code>SELECT *
  From Events
  ORDER BY HydrantId ASC
  FOR XML RAW ('Event'), ROOT ('Events'), ELEMENTS XSINIL;
  </code></pre>
  
  <p>I'm getting the following error:  </p>
  
  <pre><code>FOR XML does not support CLR types -   
  cast CLR types explicitly into one of the supported types in FOR XML queries.  
  </code></pre>
  
  <p>How can I cast this Geography column to something which is readable?<br>
  Thanks.</p>