Altering Column Data Types

[faust13]

I'm pretty sure I have the syntax, but it doesn't seem to like it:

ALTER TABLE myTbl ALTER COLUMN myColumn INT NULL

myColumn's datatype is nvarchar(30).

Thanks! ----------------------------------------
Is George Lucas Kidding...

 

[tlbroadbent]

What error are you getting?

If the column contains any non-numeric characters SQL will not alter to INT data type. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.