Anyone please help :

What is the correct SQL Syntax to modify a field in a table in a SQL Server 6.5?

eg: Table name is Sample and a field is Sampling_Point varchar(10). How do you change the field size to 15?

I tried the syntax:

ALTER TABLE Sample
MODIFY Sampling_Point varchar(15)

.......but it gives an error "modify syntax incorrect".

What is the equivalent of Modify in SQL Server's Transact SQL Statements?

Hope someone could help me with this, much appreciated.

Uma