Hi Guys,

I have a table that has a large amount of data. Most of the columns in the table have char data type. I want to change the char data type to varchar in order to save some disc space.

I tried using Alter Table alter column field1 Varchar(25), the field's data type has changed but the size of the table has increased from 25MB to 33MB.
I then tried to update the field using the following command: Update table1 set field1 = RTRIM(Field1) but to no avail, the data did not shrunk.

Am I missing something?

Thanks in advance..