title: A constant expression was encountered in the ORDER BY list, position 1
body: <p>I tried to concat two string using sql query. Below is my code which is not working.</p>
  
  <pre><code>SELECT TOP 100 CONCAT('James ','Stephen') AS [Column1] 
  FROM [dbo].[ORDERS] 
  Group BY () 
  ORDER BY CONCAT('James ','Stephen') ASC
  </code></pre>
  
  <p>If I use <code>[Column1]</code> instead of <code>CONCAT('James ','Stephen')</code> in Order by clause, it seems working. </p>
  
  <pre><code>SELECT TOP 100 CONCAT('James ','Stephen') AS [Column1] 
  FROM [dbo].[ORDERS] 
  Group by () 
  ORDER BY [Column1] ASC
  </code></pre>
  
  <p>Can anyone explain me, why did not the first query work?</p>