title: ORDER BY specific values first in SQL Server
body: <p>I can not figure this one out for the life of me, please help. I am using SQL Server and I need help with the ORDER BY Clause.</p>
  
  <p>I want this..</p>
  
  <pre><code>ID     Name
  --------------
  1      Orange
  2      Yellow
  3      Green
  4      Purple
  5      Red
  </code></pre>
  
  <p>To order like this</p>
  
  <pre><code>ID     Name
  --------------
  4      Purple   &lt;-- This one first then ASC afterwards
  3      Green
  1      Orange
  5      Red
  2      Yellow        
  </code></pre>
  
  <p>Sort of something like </p>
  
  <pre><code>ORDER BY ID=4, Name ASC
  </code></pre>
  
  <p>I used to use field in MySQL but you can't use that in SQL Server.</p>
  
  <p>Please help.</p>