How to increase Table column length size with Table Data?

How to increase Table column length size with Table Data?


When table have a data then u cant able to modify column size's like
while you do Right click table and click modify then increase/decrease size then u can get error like see below:

But to avoid this error  u can use T-SQL code like

ALTER TABLE TABLENAME ALTER COLUMN DATATYPE()