Submitted by: Emil Ojackov (finalist)

I need to extend the lenght of a VARCHAR field in a FIREBIRD database (table).
I need to do it keeping the stored information in the table.
Is it possible ?
( I did it, but I lost all the stored information in the table. I used the following syntax:
ALTER TABLE table_name ALTER field_name TYPE VARCHAR(48)
)
After I executed the above command, it was really extended the field length to varchar(48), but the table was empty as a result, that I don't like. I need to keep all the information in that table.
Thanks !