I have myTable with MyColumn VARCHAR(50)

I need to change the length of this field to 100

I tried

ALTER TABLE myTable ALTER COLUMN myColumn VARCHAR(100);

but that generated an error. So I tried

ALTER TABLE myTable CHANGE myColumn myColumn VARCHAR(100);

but that generated the same error.

I can drop the column and recreate it, but I'm wondering what the correct syntax is.

Thanks to all..........Rich

UPDATE.......the second command worked. I had not editted the original command correctly in the viewer.