>>>>>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.
The COLLATE clause is throwing me then - AFAIK that should not be in a select statement..?
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________