Forum Discussion

njahagirdar's avatar
njahagirdar
New Contributor
5 years ago

Error converting nvarchar to decimal

Hello Team, Good Evening!! I am trying to insert a record to SQL server which contains nvarchar and can someone help me in getting it converted to decimal because I receive the error mentioned be...
mbowen's avatar
mbowen
Employee
5 years ago
Copy Link

Hi Neeraj:

I suspect the problem is with the scientific notation. This is a very small negative number. Some experiments on the SQL server side.

SELECT ISNUMERIC('-3.56443E-35')
    -> 1

SELECT convert(decimal(15,2), '-3.56443E-35') 
    -> error: Error converting data type varchar to numeric.

SELECT try_convert(decimal(15,2), '-3.56443E-35') 
    -> NULL

SELECT convert(float, '-3.56443E-35') 
    -> -3.5644300000000002E-35

The are some Number functions in our expression language. toFixed() would convert number to a representation with a fixed number of digits after the decimal point, effectively 0 in this case.

Number Functions: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439371/Number+Functions+and+Properties