How to write a case statement in a data source query using the Microsoft ODBC Text driver.
The syntax for a case statement using the Microsoft ODBC Text driver is different than it would be in SQL. This is an example of a case statement:
iif(F15=’DropShip’,’1661′,’2684′) as ACCT
This is an if statement that says if column F15= DropShip then the value returned is 1661, else it is 2684 (Note there are two “i” characters at the beginning of the if statement). The column name is returned is aliased as ACCT