title: SQL Server : how to combine CASE WHEN IS NULL with OR statement
body: <p>I have a working statement that I need to expand to include another value; that value is <code>0</code>. Right now, my statement is as follows:</p>
  
  <pre><code>CASE 
     WHEN dbo.tbl.Price IS NULL 
        THEN CAST(dbo.tbl.cost AS NUMERIC(18 , 1)) * 2.2 
     ELSE dbo.tbl.Price 
  END
  </code></pre>
  
  <p>I have tried several ways of to re-write this with the <code>OR</code> operator without success.</p>
  
  <p>Including the following:</p>
  
  <pre><code>CASE 
     WHEN dbo.tbl.Price IS NULL 
        THEN CAST(dbo.tbl.cost AS NUMERIC(18 , 1)) * 2.2 
     OR WHEN 0 
        THEN CAST(dbo.tbl.cost AS NUMERIC(18 , 1)) * 2.2 
     ELSE dbo.tbl.Price 
  END
  </code></pre>
  
  <p>Can anyone assist?</p>
  
  <p>Thanks</p>