title: in SQL Server, can i convert a column from being a varchar to an int datatype
body: <p>all of my data for existing records in this column are integers but the SQL server mgmt studio GUI doesn't seem to let me modify this column as it complains it has to drop and readd the table.</p>
  
  <p>Is there any workaround to convert a columns from varchar(null) to an int field?</p>