title: Convert Varchar to Date type (not just to run a query, actually changing the column on the table)
body: <p>This was asked several times but I wasn't able to implement any of the answers.</p>
  <p>I have a table with a column with Dates that has been created as VARCHAR, I want to convert it to Date(103).</p>
  <p>I've seen several responses with the following:</p>
  <pre><code>SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]
  </code></pre>
  <p>This will work nicely to convert the result of a query...but I want to convert the actual column not just when I do a select query.</p>
  <p>I probably just don't understand where to put this line of SQL code. Can anyone help me out?</p>