string to Decimal conversion
Posted: Thu Dec 28, 2006 5:12 am
hi all,
I have an issue after i convert string to decimal..
this is the derivation for the column which is of decimal 5 as length and precision as 1, "if condtn then (stringtodecimal(column1[4,2])) else null" .
i dont understand how i can get a value 0490.0, for the input 000490.
It has a space as the first character in the output. how can it store a character (space) in a decimal field?
pls help me in solving this..
I have an issue after i convert string to decimal..
this is the derivation for the column which is of decimal 5 as length and precision as 1, "if condtn then (stringtodecimal(column1[4,2])) else null" .
i dont understand how i can get a value 0490.0, for the input 000490.
It has a space as the first character in the output. how can it store a character (space) in a decimal field?
pls help me in solving this..