how to properly do a T-SQL case statement in my code as shown below. TIA : declare @result as decimal(18, 2)
select @result = sum(basepay)
case @result when
null then 0.00
end

 from dbo.tblPayments where ClientID = 1 and month(paymentfor) = 1
print @result