>I get an error on the WorkPhone column that is doesn't like the quotes. How do I create an empty column?
>
>

>	[Phone] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
>	'' AS WorkPhone,
>

select *, cast('' as varchar(12)) as WorkPhone from People

if you need this in the SELECT-SQL.

It's usually easier to create tables in the designer and then just script them.