String to Decimal Conversion

[Rajneesh1990]

Hi All,

What is mean by rtype in Type Conversion Function
StringToDecimal(%string%,[%rtype%])??

suppose my input is sal=126540 and i need output like 126540.00

Can Anybody Explain with Example ???


Thanks,
Rajneesh.

[jwiles]

Rounding type. It is documented here: http://publib.boulder.ibm.com/infocente ... 0%65%22%20

[Rajneesh1990]

Thanks jwiles,

I Practiced and found the answer of my Query .
Conversion should be Like Below :

StringToDecimal(<Input Column>,'2').

2 is the Precision Place in case of Decimal, but in String Format.

Thanks :D ,
Rajneesh.