[dbo].[progedd_pre].[end]

Thanks.

__Stephen

>>>I have some legacy FP data that was pulled into SS200 via DTS package. I was just asked to add a column from one of those table to a separate look up table. This is a trick question now ----
>>>
>>>How do you reference a column name "END".
>>>
>>>I need to do this to beat some old Access people.
>>>
>>>__Stephen
>>If the QUOTED_IDENTIFIER option is set ON then you can use double quotes
>>
>>SELECT "END" FROM Mytable
>>
>>Or you can use brakets []
>>
>>SELECT [END] FROM Mytable
>
>You can use brakets [] regardlesss of the QUOTED_IDENTIFIER option setting.