Re: SAPDB DECODE statement problem

Yes, unfortunately I did try to cast the zero as floating-point, but it had 
no effect on the result.  However, another post alerted me to the VALUE() 
function which works and seems to handle the nulls better.   SELECT  VALUE( 
T.COL1,  0 ) NEW_COL
   FROM TABLEA T;  works in this case to convert the nulls to zeros and 
preserves the float precision.

Thanks for the help

_________________________________________________________________
MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup