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

Do you have a link for this?

Renoir