SQL version 8.0 - Invalid column name

[Steven de Vries]

Hi,

I'am trying a very simple sql statement but it does not work.
I use the SQL version 8.0
I use the "Northwind" sample database and the Table "Employees".

The sql statement is:

SELECT * From Employees Where City = "London"

The returned message is:

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'London'.

Can somebody tell me what could be wrong?
Greetings,
Steven de Vries

[John Bell]

Hi

This is because of the QUOTED IDENTIFIERS setting being ON

either set them off
SET QUOTED_IDENTIFIER OFF
SELECT * From Employees Where City = "London"

or
SELECT * From Employees Where City = 'London'

For more information see Books online or
http://msdn.microsoft.com/library/de...asp?frame=true

John

"Steven de Vries" <st*****@xs4all.nl> wrote in message
news:e6*************************@posting.google.co m...

Hi,

I'am trying a very simple sql statement but it does not work.
I use the SQL version 8.0
I use the "Northwind" sample database and the Table "Employees".

The sql statement is:

SELECT * From Employees Where City = "London"

The returned message is:

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'London'.

Can somebody tell me what could be wrong?
Greetings,
Steven de Vries

[Steven de Vries]

Thank you very much.

Gert-Jan Strik <so***@toomuchspamalready.nl> wrote in message news:<3F***************@toomuchspamalready.nl>...

In SQL, the string delimiter is a single quote, for example

SELECT * From Employees Where City = 'London'

The double quotes are reserved for object names with special characters.
You should not use them as string delimiter. For example

SELECT OrderID AS "Order ID" FROM "Order Details"

(In SQL-Server you will often see the proprietary syntax with brackets
to name objects.)

Gert-Jan
Steven de Vries wrote:

Hi,

I'am trying a very simple sql statement but it does not work.
I use the SQL version 8.0
I use the "Northwind" sample database and the Table "Employees".

The sql statement is:

SELECT * From Employees Where City = "London"

The returned message is:

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'London'.

Can somebody tell me what could be wrong?
Greetings,
Steven de Vries

[Matt]

Steven,

Use single quotes. The correct statement is

SELECT * FROM Employees WHERE City = 'London'

HTH

Matt

"Steven de Vries" <st*****@xs4all.nl> wrote in message
news:e6*************************@posting.google.co m...

Hi,

I'am trying a very simple sql statement but it does not work.
I use the SQL version 8.0
I use the "Northwind" sample database and the Table "Employees".

The sql statement is:

SELECT * From Employees Where City = "London"

The returned message is:

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'London'.

Can somebody tell me what could be wrong?
Greetings,
Steven de Vries