Reported By: Robert Kaplan Reported On: 12/19/2001 For: Version 3.03 Build 1
# 988CAST Function Not Working Properly When Casting to DECIMAL (BCD) Field Type The following SQL returns 0 for the InUse column even though it should not:
SELECT ID, CR_NAME, CR_SHNAME,
PL_CUST, SUM(PL_TOTPRIN) Balance, SUM(IF (PL_UNDERLINE = FALSE THEN
CAST (0 AS DECIMAL) ELSE PL_TOTPRIN)) InUse
FROM PLANS
LEFT OUTER JOIN CUSTTABLE ON ID = PL_CUST
group by ID
ORDER BY CR_SHNAME
ResolutionFixed Problem on 12/20/2001 in version 3.04 build 1