title: Converting Geography data type column to a NVARCHAR
body: <p>I have a column in my database of data type Geography which I want to convert to a varchar.</p>
  
  <p>I am using the following query to make do this ...</p>
  
  <p>-- 1: Issue with Microsoft.SqlServer.Types.dll.</p>
  
  <pre><code>ALTER TABLE RetailerStore ALTER COLUMN Location VARCHAR(50)
  </code></pre>
  
  <p>However, I get the error message</p>
  
  <blockquote>
    <p>Msg 257, Level 16, State 3, Line 1<br>
    Implicit conversion from data type geography to varchar is not allowed. Use the CONVERT function to run this query.</p>
  </blockquote>
  
  <p>Has anybody come across this and if so do they know a way to resolve it?</p>