The following doesn't work with operator "<' and 0.....All fields are character from DB2. I know I need to cast the data into an Integer? Can't seem to get around it ...Any thoughts?

Select

SUM (Case a.BIL_AMT WHEN > 0 Then 0 ELSE a.BIL_AMT END) - a.BIL_CRY_FWD_AMT) AS "Current Amt Due"

From a.Bill