Kevin Heil 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?
As mentioned in earlier mails: VALUE (T.COL1, 0) is THE function to convert the NULL-value to another one (more convenient for summing_up or the like), without changes to other values of that column. Yes, this behaviour mentioned above is a bug, which of course will be fixed with the next version, see PTS 1123807. Thank you for reporting Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
