have you tried this:

alter table <tablename> alter column <columnname> type varchar(##);

where ## is the new size of your field.