title: SQL Server Sorting
body: <p>I am trying to sort dates in my SQL server but I am facing trouble sorting String field in the correct order. The query returns <code>Week 9 FY18</code> value in the column before <code>Week 52 FY18</code>.</p>
  
  <p>How do I fix this problem in my query. This is the query I am using right now.</p>
  
  <pre><code>SELECT
      [Forecast Week],
      ProductGroup,
      Product,
      Week,
      [Ex Factory Supply Plan Total]
  FROM
      anaplan.exfactorysupply_staging
  WHERE
      ProductGroup IN (
                          'BEAM'
                      )
      AND Week = 'Week 19 FY18'
  ORDER BY
      [Forecast Week] DESC;
  </code></pre>