Hi All, I have a Table called Table1, in that I have a column called Status which is of type Varchar and contains values link '1', '2', '3' etc, i.e. all integer values only but in Varchar type. I need to change this column's datatype to Integer for some reason, any idea how do we do it ? I am trying like: ALTER TABLE Table1 ALTER STATUS TYPE Integer; But I am getting an error like, "Cannot change datatype......."
Thanks In Advance. With Best Regards. Vishal