title: SQL Placeholders/Wildcards
body: <p>I currently have a date column (I'm new and learning) that is a VARCHAR structure and I was inserting into the column using mm/dd/yyyy. </p>
  
  <p>Later realised this wasn't proper and to use the DATE structure and YYYY-MM-DD</p>
  
  <p>Instead of purging my table I want to be able to convert my mm/dd/yyy's into a suitable YYYY-MM-DD so I can then change the column structure to DATE</p>
  
  <p>My first step was to replace all the /'s with -'s so I tried:</p>
  
  <p><code>REPLACE ("__/__/__", "/", "-");
  </code></p>
  
  <p>But obviously got unexpected token errors. How can I go about achieving what I want to do?</p>