Hi Rich,
1) What error return AERROR()?
2) Have you access for ALTER TABLE on database or the table?
MartiJ
>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.