Forum Discussion
ODBC SQL incorrect syntax near '='
Hello, I am trying to run this SQL using ODBC connection in Power Query: SELECT
IIF(column1 = 'C', Left(column2,10), '') AS 'Column3'
FROM table But keep getting the following error:...
Hey Anonymous
Usually when I see this error it is due to the single quotes for the declaration try removing the single quotes on Column3.
You can also try adding double quotes, however if you do this in Power Query via Advanced Editor then you'll need double quotes x2 like ""Column3"".
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.