I have been having a problem using the DECODE statement in SQL. It seems that when I use the decode statement on a floating-point column, it truncates the result. I cannot figure out a way around this. An example SQL statement is:
SELECT DECODE(T.COL1, null, 0, T.COL1) NEW_COL FROM TABLEA T;
Have you already tried DECODE(t.col1, null, 0.0, t.col1) or to cast the 0 into a float?
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
