Changing the data type of a column
Posted on 2006-11-28
I am updating a column datatype integer to varchar(3) with the following script
ALTER TABLE mythirdTable
ALTER COLUMN [Column2] [varchar] (3) NOT NULL
after changiging the column type, i am inserting values in to my table and still getting the error related to the data type of the column I have changed. Can you please help why this is happening or if I am doing anything wrong?
INSERT INTO mythirdTable
Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the varchar value '2G8' to a column of data type int.