>>>> [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, >>>>
>>Msg 173, Level 15, State 1, Line 12 >>The definition for column 'cast' must include a data type. >>>