Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need syntax for Select statement
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01016740
Message ID:
01016766
Views:
10
>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).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform