JElster
asked on
Error converting data type nvarchar to numeric.
Trying to update a MONEY col with values from a nvarchar(20)
I get the error Error converting data type nvarchar to numeric.
How do I do this.. the data in the format "123.50"
I get the error Error converting data type nvarchar to numeric.
How do I do this.. the data in the format "123.50"
ASKER
Cannot convert a char value to money. The char value has incorrect syntax.
select Cast(commsamt as money) from Commissions
Commsamt is nvarchar 20 " 1243.54"
select Cast(commsamt as money) from Commissions
Commsamt is nvarchar 20 " 1243.54"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
cast(NvarcharField as money)