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

>>
>>

>>	cast('' as varchar(12)) AS WorkPhone,
>>

>>
>>Error:
>>
>>

>>Msg 173, Level 15, State 1, Line 12
>>The definition for column 'cast' must include a data type.
>>

>
>Jay - are you trying to do a select or create a table - I'm assuming you are creating a table..?

Select.