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.
Well, i guess this is a bug than.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
