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
Title:
Need syntax for Select statement
Miscellaneous
Thread ID:
01016740
Message ID:
01016740
Views:
52
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?
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).
Next
Reply
Map
View

Click here to load this message in the networking platform