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

SQL BOL are on MSDN : http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/portal_7ap1.htm

You can also download the BOL at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp