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