Change varchar column length, when column does not match given length in T-SQL.
The following code will update a column to varchar(max) only, when it does not already have the varchar(max) length. -- Update column 'Name' length, it should be varchar(max). -- Note: varchar(max) has length '-1'. if