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