title: SQL Server : CASE statement multiplication
body: <p>I'm having an issue with this line of code.</p>
  
  <p>I'm trying to calculate or multiply numbers from .01 to .04 by .25 and anything above .04 is multiplied by 1. It works when I multiply a number higher that .04 for example .05 it multiplies it by .01 but anything below .05 does not get multiplied by .25. Can someone please help? Thanks!</p>
  
  <p>Here's the what I have:</p>
  
  <p>This is the new one</p>
  
  <pre><code>CASE WHEN curOther IS  THEN curOther + .01 ELSE (curOther * .25) + curOther END
  </code></pre>
  
  <p>This is the original</p>
  
  <pre><code>CASE WHEN curOther &gt; .04 then .01 ELSE curOther * .25 + curOther END
  </code></pre>