> ALTER TABLE Gen_Demo ADD email4 VARCHAR(50)
> go
> ALTER TABLE Gen_Demo ALTER COLUMN email4 VARCHAR(101)
> go
>
> when executed in Query Analyzer -
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'COLUMN'.
>
> however this same code works on a friends SQL Server
>
> Any ideas ?