RE: SAPDB DECODE statement problem

Thank you very much - that worked perfectly!


>From: "Alejandro Michelin Salomon \( Adinet \)" <[email protected]>
>To: <[email protected]>
>Subject: RE: SAPDB DECODE statement problem
>Date: Tue, 26 Aug 2003 17:48:41 -0300
>
>Kevin wrote :
>
> >    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
>
>You have to use VALUE();
>
>  SELECT  VALUE( T.COL1,  0 ) NEW_COL
>    FROM TABLEA T;
>
>Alejandro Michelin Salomon
>PROBrax e-tech
>Brasil
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

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