title: Convert varchar dd-mmm-yyyy to dd/mm/yyyy then order by not working?
body: <p>I have a situation</p>
  
  <ol>
  <li><p>I need to convert a <code>varchar</code> value from <code>dd-mmm-yyyy</code> to <code>dd/mm/yyyy</code></p></li>
  <li><p>order by above converted date</p></li>
  </ol>
  
  <p>Using</p>
  
  <pre><code>CONVERT(VARCHAR(10), CAST([Date] AS DATETIME), 103) as ModifiedDate
  </code></pre>
  
  <p>I got the required format but, when I do order by <code>ModifiedDate</code></p>
  
  <p>order by result set showing 2013, 2014, 2015 years mixed match. I think its doing order by date. Where I am doing wrong? Can anybody help? Thanks </p>