title: CASE Statement for Order By Clause with Multiple Columns and Desc/Asc Sort
body: <p>Following on from my earlier question here <a href="https://stackoverflow.com/questions/25949837/case-statement-for-order-by-clause-with-desc-asc-sort">Case statement for Order By clause with Desc/Asc sort</a> I have a statement like this:</p>
  
  <pre><code>SELECT 
      *
  FROM
      TableName
  WHERE
  ORDER BY 
      CASE @OrderByColumn WHEN 1 THEN Forename END DESC, 
      CASE @OrderByColumn WHEN 2 THEN Surname END ASC 
  </code></pre>
  
  <p>This works well, but sometimes I need more than column in the order by. I actually need something like this:</p>
  
  <pre><code>.....
  ORDER BY
      CASE @OrderByColumn WHEN 1 THEN Forename, Date, Location END DESC
  </code></pre>
  
  <p>I can't work out how to make the <code>CASE</code> statement allow multiple columns in the <code>THEN</code> part.</p>