• The IIf function is new to SQL Server 2012.