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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
