IF DB = Oracle8i then

alter table table_name modify column_name varchar2(10);

if the data in every is 10 or less characters I think that will work.