Error when trying to change data type from nvarchar to int in SQL Server 2008
Posted on 2011-09-06
I am brand new to SQL so please respond in very simple steps.
This is what I tried:
Alter Table MY TABLE NAME
Alter Column MY COLUMN NAME int
This is the error message I am receiving
(5429 row(s) affected)
Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the nvarchar value '1,500' to data type int.
The statement has been terminated.
I have 5,429 records which contain numbers and NULL values.
My goal is to use this field as part of a calculation in an access form.