Link to home
Start Free TrialLog in
Avatar of JElster
JElsterFlag for United States of America

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"
Avatar of brad2575
brad2575
Flag of United States of America image

use this to convert the field
cast(NvarcharField as money)
Avatar of JElster

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"
ASKER CERTIFIED SOLUTION
Avatar of brad2575
brad2575
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial