DSXchange

Posted: **Fri Sep 07, 2012 11:02 am**

Hi thanks for reading.

When converting string -77 from string to decimal using StringToDecimal function I lose the '-' sign....so the number becomes a positive. Anyone know of a solution for this? What the best way to conver negative string value to a decimal?

Posted: **Sat Sep 08, 2012 5:01 am**

I can't reproduce the problem on my Windows 8.7 machine, "StringToDecimal('-77')" into a Decimal(10) field keeps the negative sign.

Posted: **Sat Sep 08, 2012 2:22 pm**

What are the precision and scale settings for the Decimal target column? Does it have a specifically set display width?

DSXchange

String to Decimal - losing negative sign

String to Decimal - losing negative sign