Imagine the name of the table is "CUSTOMER", and the column name is "NAME" - which is a varchar. Here is how to change the length of the column without losing data.

ALTER TABLE CUSTOMER
ALTER COLUMN NAME
TYPE VARCHAR (64)

Average rating: