How to convert negative value into zero

Question

    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 .....

This query return some negative value,I want convert negative value into zero. How to write a query

Answer 1

Something like this maybe?

SELECT t1.name AS Name, CASE WHEN t1.Interest > 0 THEN Interest ELSE 0 END AS Interest
FROM (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 ...........) as t1

Answer 2

Just give this

select greatest(:yourval,0)

(Works in Azure and SQL Server 2022.)