You may alter a not null varchar column in T-SQL to expand its capacity so to speak.

varchar(128) may easily become varchar(max) like so:

ALTER TABLE Foo ALTER COLUMN Bar VARCHAR(MAX) NOT NULL