>
> is there any quick hacks to do this quickly? There's around 20-30million
> rows of data.
>
> I want to change a column type from varchar(4) to varchar(5) or should I
> just use text instead.
>
ALTER TABLE tablename ALTER COLUMN columnname TYPE VARCHAR(5);
HTH.
-
Eric