Re: varchar to char in table with several varchar's

At 9:32 AM +0100 12/12/01, Willem Bison wrote: >I have a table with several columns of type 'varchar'. How can I change all >columns to fixed width char's ? Doing a 'alter' from varchar to char has no >effect since the column is changed back to varchar. You have to change them all at ones in the

varchar to char in table with several varchar's

I have a table with several columns of type 'varchar'. How can I change all columns to fixed width char's ? Doing a 'alter' from varchar to char has no effect since the column is changed back to varchar. - Before posting, plea