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: