OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
SAPDB DECODE statement problem

From: Kevin Heil (kevin_heilhotmail.com)
Date: Tue Aug 26 2003 - 13:24:08 CDT

Hello,

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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general