SQL query "OBJECT" problem?

Question

Hi I have a table which contains filed name as OBJECT.
I am trying to fetch records from the table using select query as follows:

SELECT * 
  FROM table1 
 WHERE OBJECT = "11";

I am getting the following error - INVALID COLUMN NAME.
Looks like its reading OBJECT as SQL KEYWORD and not as table field name.

I am writing this query in sql server management studio.

PaulStock · Answer 1 · 2011-08-30T19:30:33.963

2

Enclose keywords in brackets:

SELECT * FROM table1 WHERE [OBJECT] = '11'

edited Aug 30 '11 at 19:30

answered Aug 30 '11 at 19:12

PaulStock

But don't enclose values in double quotes, use single quotes. – Johan Aug 30 '11 at 19:28
You're right @Johan. I was just copied his original query without double-checking. I edited my answer to use single quotes. – PaulStock Aug 30 '11 at 19:30

score 0 · Accepted Answer · edited May 23 '17 at 12:19

0

Try

select * from table1 where [OBJECT] = '11';

Btw, here is another SO-question to this issue.

edited May 23 '17 at 12:19

Community

answered Aug 30 '11 at 19:12

Tim Schmelter

score 0 · Answer 3 · answered Aug 30 '11 at 19:16

0

Use single quotation marks. But if object is numeric, don't use any quotation marks around the number 11.

             where mycol = 'x'  

             not 

           where mycol = "x"

answered Aug 30 '11 at 19:16

Tim

3 Answers3