Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have this query set up:
SELECT *
FROM "dbo"."Table"
where "COLUMN = "Value"
I get this Validation failed: Query failed: Invalid column name 'Value'.
Why does the DSS think I am saying where column = column
Hi @nshapir2,
Because 'Value' is a string literal, it needs to be enclosed in 'single quotes', not "double quotes".
SELECT *
FROM "dbo"."Table"
where "COLUMN" = 'Value'
For details, please see the following question: https://stackoverflow.com/q/1992314