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

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi Anonymous 

     

    Try this. I believe the problem is not with "=", but the condition expression. Also I hope the datatype of Column2 is also varchar, else it could be problem too.

     

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

     

    Thanks!