IIF in SQL server

From: MichaelK (michaelk_at_gomobile.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 12:51:12 -0700

Is there a way in SQL Server to run the simple query
having something like IIF function in Access.
Similar to this easy query.

SELECT Mobile,iif([PlanType]=1, "New", "Upgrade") As Type FROM Acts WHERE
(RepId = 2194)

Thanks,
Michael