DECLARE @Id Int                               
SELECT @Id = Id From sysobjects Where Name = 'Tbl_ClubH'
IF  Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Addr')
ALTER TABLE Tbl_ClubH ALTER COLUMN Addr NVARCHAR(max)