Query an Excel file using CASE statement

[ruve1k]

I have a query which uses another excel file as the data source. When I add a CASE statement to the query I get the following error: "syntax error (missing operator) in query expression"
The syntax I used is as follows:

case when column1 = 'Other' then column2 else column1 end as MyColumn

Apparently there are issues with using a CASE statement in a query that targets an excel file.
What is the syntax for a conditional statement in the SELECT clause of a SQL query which targets an excel file?
Thanks!

 

[Ruddles]

I think it's case variable when value rather than case when variable=value. Try:-

case column1 when 'Other' then column2 else column1 end as MyColumn

For two values, use IIF:-

IIF(column1 = 'Other', column2, column1) as MyColumn