title: How do I do multiple CASE WHEN conditions using SQL Server 2008?
body: <p>What I'm trying to do is use more than one CASE WHEN condition for the same column.</p>
  
  <p>Here is my code for the query:</p>
  
  <pre><code>   SELECT   Url='',
              p.ArtNo,
              p.[Description],
              p.Specification,
              CASE 
              WHEN 1 = 1 or 1 = 1 
                 THEN 1 
                 ELSE 0 
              END as Qty,
              p.NetPrice,
              [Status] = 0
        FROM  Product p (NOLOCK)
  </code></pre>
  
  <p>However, what I want to do is use more then one WHEN for the same column "qty".</p>
  
  <p>As in the following code:</p>
  
  <pre><code>IF
  // CODE
  ELSE IF
  // CODE
  ELSE IF
  // CODE
  ELSE
  // CODE
  </code></pre>