create a new column . update it from first and drop it.