USE [EnVisage]
GO
if exists(select * from sys.columns 
            where Name = N'Weekends' and Object_ID = Object_ID(N'Training'))
begin
    alter table Training drop column Weekends
end

alter table Training add Weekends nvarchar(256)
update Training set Weekends = ''
alter table Training alter column Weekends nvarchar(256) not null