title: SQL Max(something,0) type solution
body: <p>I would like to do the following:</p>
  
  <p>SELECT sum(max(field-10,000,0)) from TABLE</p>
  
  <p>as in, I want to have field-10,000 summed up, but if field-10,000 &lt; 0 then I want it to add 0.</p>
  
  <p>any suggestions?</p>
  
  <p>Karl</p>