Microsoft® SQL Server 2012 Unleashed

The IIF Function

The IIF function in SQL Server 2012 is essentially a shorthand version of the CASE expression. The syntax is as follows:

Click here to view code image

IIF ( boolean_expression, true_value, false_value )

The Boolean expression passed as the first argument is evaluated, and the function returns the true_value if the Boolean expression is true; otherwise, the false_value is returned. The following is an example of the IIF function:

Click here to view code image

SELECT ProductID,       IIF(Rating > 3, 'Highly Rated', 'Poor Rating') AS RatingFROM production.ProductReview prGO/*  ProductID Rating----------- ------------        709 Highly Rated        937 Highly Rated        937 Poor Rating        798 Highly Rated*/