* IIF is a Shorthand way of writing Case expression. Syntex: IIF(boolean_expression, true_value, false_value) IIF (id=1, 'MALE', 'FEMALE') as Gender, IIF (id=1, 'MALE ...