>I beleive the CASE statement is what you would use, although there may be something else more appropriate. Someone will jump in and correct me if I'm wrong. :-)

Yep, jump over to the SQL Server forum and get all messages from last week. See the thread, "Problem with SELECT and IIF"