>Try
SET QUOTED_IDENTIFIER ON
>Select "contact[1]", "phone[1]" From Customers
>
>>I have a table, lets call it customers, with the following fields:
>>
>>contact[1]
>>contact[2]
>>contact[3]
>>phone[1]
>>phone[2]
>>phone[3]
>>
>>I want to select the contact[1] and phone[1] fields. What is the syntax to select these two fields? I have tried "Select [contact[1]], [contact[2]] From Customers" and every combination of [] you can think of with no luck. Can someone help me out?
Many thanks, Sergey. That solved my problem.
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).