Conditional SELECT fail - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Conditional SELECT fail

Author

Topic

urmas80
Starting Member

20 Posts

Posted - 2012-07-06 : 02:45:12

Hi again,

I am using conditional select with a following synatx, but when i am writing the condition i got this error:

SELECT * FROM Customers
WHERE (["Customers ID"] = "1111")

Invalid column name '1111'.

In the customers table the format of the data is as written in the condition ["1111"], with the ".

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-07-06 : 03:47:10

use single quotes

SELECT * FROM Customers
WHERE ["Customers ID"] = '"1111"'

But I must say that is a mess!

No, you're never too old to Yak'n'Roll if you're too young to die.