title: SQL select case when clause
body: <p>The following is the query</p>
  
  <pre><code>select *,  "Price Range" = 
    CASE 
       WHEN ListPrice =  0 THEN 'Mfg item - not for resale'
       WHEN ListPrice &lt; 50 THEN 'Under $50'
       WHEN ListPrice &gt;= 50 and ListPrice &lt; 250 THEN 'Under $250'
       WHEN ListPrice &gt;= 250 and ListPrice &lt; 1000 THEN 'Under $1000'
       ELSE 'Over $1000'
    END
    FROM Production.Product
        ORDER BY ProductNumber
  </code></pre>
  
  <p>But there is SQL error, missing important words before FROM.</p>
  
  <p>What is the blueprint for us to use <code>case</code> if I want to select all the columns ?</p>