For more information, see CASE (Transact-SQL). The fact that IIF is translated into CASE also has an impact on other aspects of the behavior of this function. Since CASE expressions can be nested only ...