>>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,
>>

>
>workphone varchar(20) DEFAULT '' NOT NULL

	Reserved01 varchar(20) DEFAULT '' NOT NULL,

Error:

Msg 102, Level 15, State 1, Line 27
Incorrect syntax near ')'.