if (SELECT c.max_length From sys.tables AS t Inner Join sys.columns c On t.Object_ID = c.Object_ID where t.name = 'Bargeh' and c.name = 'Sharh') < 1000 begin alter table Bargeh alter column Sharh nvarchar(1000) end