Naomi,

You are correct, you can ADD multiple columns in a single statement, but you can only ALTER one column at a time in a SQL statement.

Kurt
>Kurt,
>
>Can you alter two columns at once? There is no sample in BOL and I assume it's impossible.
>
>I need
>ALTER TABLE Friends ALTER COLUMN [EmergencyContactPhone1] [varchar](25) NULL,
> [EmergencyContactPhone] [varchar](25) NULL
>
>
>(change type of both columns).