> alter table atable drop surname;
> commit;
> alter table atable add surname varchar(30);
> commit;
> update atable set surname = newsurname;
> commit;
> alter table drop newsurname,

Any particular reason for not using "alter table atable alter
newsurname to surname;"?

--
Erick Sasse