hello everybody,<BR><BR>what is the correct syntax for modifiying a column in an SQL Server using an SQL Statement.<BR><BR>I have a table on an SQL Server with a Column<BR>Province VARCHAR(30)<BR><BR>and I want to modify this column to <BR>Province VARCHAR(50)<BR><BR>what is the correct syntax?<BR>What I am guessing is... <BR><BR>Alter Table MyTable Modify Column Province...<BR>(but then what?)<BR><BR>Thanks for your help,<BR>Andre