Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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:...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

"," in the end of the statement could be the cause of error. Try this

 

SELECT
IIF(column1 = 'C', Left(column2,10), '') AS 'Column3'
FROM table

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Thanks for the help. I removed the "," in the end and still get the same error.  The error shows for something with the "=".

     

    Vivek

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Well in that case, what's the datatype of Column1?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        AnonymousThe datatype is text for Column1