>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.

See Sergey's reply. Also read the SQL books online on CASE (T-SQL).