Hi, I have a table as follows that i am tring to alter but getting
error message...

CREATE TABLE [dbo].[test111] (
[Lname] [varchar] (10) COLLATE SQL_Latin1_General_CP850_CI_AS NULL
) ON [PRIMARY]
GO

I am tring to alter column Lname to varchar(20) with following syntex..

alter table test111 alter column Lname varchar(20) NULL

This is giving me error...
Incorrect syntax near 'column'.

What is that I am doing wrong?? Please help!!!!!!!!

-Payal

The Syntax is correct check it again

Madhivanan