SQL Server Version 5??? I didn't even know there was a version that old. Where did you download it from? Besides, as I said in my earlier post ... the ALTER COLUMN syntax was not introduced in SQL Server until Version 7. That explains your syntax error.

~~Bonnie



>Hello Bonnie,
>
>I am using version 5.0 ( build 2195:Service Pack 3). This is a trial version that I downloaded.
>
>I do not understand why I get this error. I looked at the syntax from the on-line books and it looks like I am doing it correct.
>
>Sergio