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;
If, for example, T.COL1 is 4.77, the result is "4". If the T.COL1 is null, 0 appears correctly.
Has anyone experienced this before?
Thanks,
Kevin
_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection. http://join.msn.com/?page=features/virus
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
