Re: SAPDB DECODE statement problem

Sven Köhler <[email protected]> Wed, 27 Aug 2003 00:35:31 +0200

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<[email protected]>

> 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.