title: How to convert negative value into zero
body: <pre><code>    SELECT  name ,
          ( SUM(CASE WHEN TransTypeName LIKE 'credit%' THEN amount
                     ELSE 0
                END) - SUM(CASE WHEN TransTypeName LIKE 'Debit%' THEN amount
                                ELSE 0
                           END) ) * 5 / 100 AS Interest
      FROM .....
  </code></pre>
  
  <p>This query return some negative value,I want convert negative value into zero.
  How to write a query</p>