SAPDB DECODE statement problem

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