How can i query for a column in SQL that contains a Parenthesis in its name?

Question

Somone created a column in our SQL table that has a parenthesis in its name. (e.g. "column3(d)"). When i try to execute "Select columtn3(d) From Table1" i get an error. How can i escape or otherwise get results for this colum via the select statement?

any help would be much appreiated!!

Answer 1

I would never use a column name with a parenthesis in it, so I think you should change that first.

Just call the column name instead....like select 1 from table etc...if its in column 1.