12-31-03, 14:10 #1Registered User
- Join Date
- Nov 2003
Unanswered: Cast character into integer for Case Statement
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?
SUM (Case a.BIL_AMT WHEN > 0 Then 0 ELSE a.BIL_AMT END) - a.BIL_CRY_FWD_AMT) AS "Current Amt Due"