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