title: Convert Text to Date in SQL Server
body: <p>How to I convert a text value like "18/06/11" to a date format like "2011-06-18"?</p>
  
  <p>I have tried the following</p>
  
  <p>convert(char,[InstrumentText], 106) </p>
  
  <p>but the value just stays in the same format </p>
  
  <p>Thanks </p>