• If column is Numeric then frist convert to varchar(8)

    Alter table <Table name> Alter column <COlumn Name> varchar(8)