Using IIf in TSQL

Using IIF in Access I am currently moving a client from an Access DB to MS SQL Server 2008, and came up to a problem when I had to move a query to a view.  The query: Using CASE in TSQL Use the CASE expression Thanks to: http://www.sql-server-performance.com/faq/iif_tsql_p1.aspx