IIF (Transact-SQL) - Arguments. 1  A valid Boolean expression. 2  If this argument is not a Boolean expression, then a syntax error is raised. 3  Value to return if boolean_expression evaluates to true. 4  Value to return if boolean_expression evaluates to false.