String to Decimal - losing negative sign

Marley777 · Post by **Marley777** » 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?

ArndW · Post by **ArndW** » 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.

ray.wurlod · Post by **ray.wurlod** » 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?