Yes. If you want to lengthen a column, use ALTER TABLE to assign new data length. If you want to shorten the column, you'll want to drop/add the table or add the new column, copy the data, drop the existing column and sp_rename the column.
John Rowan
====================================================== ====================================================== Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden