alter table PUB_SPR_B rename column GLDW to q;
alter table PUB_SPR_B add GLDW varchar2(200 char);
update PUB_SPR_B set GLDW=trim(q);
alter table PUB_SPR_B drop column q;
alter table PUB_SPR_B rename column GLDW to q;
alter table PUB_SPR_B add GLDW varchar2(200 char);
update PUB_SPR_B set GLDW=trim(q);
alter table PUB_SPR_B drop column q;