Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
SAPDB DECODE statement problem
From: Kevin Heil (kevin_heilhotmail.com)
Date: Tue Aug 26 2003 - 13:24:08 CDT
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?
Get MSN 8 and enjoy automatic e-mail virus protection.
sapdb.general mailing list