IIF (Transact-SQL) - Remarks. 1  IIF is a shorthand way for writing a CASE expression. 2  The fact that IIF is translated into CASE also has an impact on other aspects of the behavior of this function.