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 · Accepted Answer · 2011-08-30 19:30:33Z

2

Enclose keywords in brackets:

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

edited Aug 30, 2011 at 19:30

answered Aug 30, 2011 at 19:12

PaulStock

11.3k9 gold badges51 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Johan Over a year ago

But don't enclose values in double quotes, use single quotes.

PaulStock Over a year ago

You're right @Johan. I was just copied his original query without double-checking. I edited my answer to use single quotes.

Community · Accepted Answer · 2017-05-23 12:19:03Z

0

Try

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

MSDN: Delimited Identifiers

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

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Aug 30, 2011 at 19:12

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

Comments

Tim · Accepted Answer · 2011-08-30 19:16:48Z

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, 2011 at 19:16

Tim

8,99031 gold badges111 silver badges197 bronze badges

1 Comment

CPDS Over a year ago

Thanks.. I realized the problem.

Collectives™ on Stack Overflow

SQL query "OBJECT" problem?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related