>I am not sure if this would work inside of SELECT statement.
>What I am trying to do is:
>
>SELECT FROM myTable.*, IIF(myTable.GoodBad, "Good", "Bad") as MyExp
>
>I need to add few calculated fields to my query.

Yes it will work in select

SELECT *,  CASE WHEN myTable.GoodBad=1 THEN  'Good' ELSE 'Bad' END as MyExp
    FROM mytable