Skip to Content
0
Former Member
Jan 29, 2016 at 09:42 AM

to_decimal function in BODS 14.0 and 14.02 gave different results

1698 Views

I have table with column1 and column2. I would like to add new column (for example column3 name) in BODS using definition:

table.column1*100

+to_decimal( nvl(table.column2,'0'),'','',0)

Column1 contain value 2011001100 and column2 is empty (contain space). In BODS 14.0 column3 contain 201100110000 but in BODS 14.2 I received NULL and I do not know why (definitions are the same in BODS 14.0 and 14.2).