IIF (Transact-SQL) - Remarks. 1  IIF is a shorthand way for writing a CASE expression. It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the evaluation. 2  The fact that IIF is translated into CASE also has an impact on other aspects of the behavior of this function.