Select Query with column name containing [] [Figured out]

[dan sh]

I have a columns say, Col and Col[1] in table say Test. Now I want to do a select from it. How to go about it? (Since [] has a special meaning for SQl server) I tried

select Col,Col[1] from Test

but for obvious reasons, it does not works. [Edit] This will work:

Select Col,[Col[1]]] from Test

[/Edit]

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

modified on Thursday, December 17, 2009 12:59 AM

[Mycroft Holmes]

try

select Col,[Col[1]] from Test

Who would be dumb enough to use reserved words or characters in a column name. Stoopid really.

Never underestimate the power of human stupidity RAH

[dan sh]

Mycroft Holmes wrote:

Who would be dumb enough to use reserved words or characters in a column name.

Well, I just did that to find how SQL will behave.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Mycroft Holmes]

Did not even look at the moniker before answering otherwise I'd have been questioning your sanity. Doing that is akin to sticking your finger in the power point, may not kill you but your fingers gonna sting for a while. So did the extra set of brackets work? I flatly refuse to try it out

Never underestimate the power of human stupidity RAH

[dan sh]

Mycroft Holmes wrote:

Doing that is akin to sticking your finger in the power point, may not kill you but your fingers gonna sting for a while.

:laugh: Never tried this.

Mycroft Holmes wrote:

So did the extra set of brackets work?

Yes it did.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!