title: 0 come last when sorting ascending
body: <p>I am trying to select from one table a list of products ordered by price, year, name, and others....
  The problem is that I must make zero values come last when sorting ascending.</p>
  
  <p>My code is:</p>
  
  <pre><code>SELECT * FROM Product P 
  ORDER BY  CASE WHEN @OrderBy='Date ASC' THEN Date  END ASC,
            CASE WHEN @OrderBy='Price ASC' THEN Price  END ASC,
            CASE WHEN @OrderBy='Title ASC' THEN Title  END ASC,
            CASE WHEN @OrderBy='' THEN Match END
  </code></pre>
  
  <p>This works but don't put the zero at the bottom of the list.
  So, I tried to transform it (see next code), but it gave me the error <em>Incorrect syntax near ','</em>. </p>
  
  <pre><code>SELECT * FROM Product P
  ORDER BY CASE WHEN @OrderBy='Price ASC' THEN 
  
             (case A.Price WHEN  0 THEN 1 ELSE 0  END,A.Price )
  
  END ASC
  </code></pre>
  
  <p></p>
  
  <p>I appreciate any help</p>