IIF Function in sql server

The IIF function is a shorthand version for the CASE statement. The syntax for the IIF function is as follows:

IIF (boolean_expression, true_value, false_value)

The function behaves exactly as it does in Microsoft Excel. If the Boolean expression evaluates to true, the first value is return, and if it evaluates to false, the second value is returned. The following script illustrates the use of the function:

SELECT IIF (1=1, 'True', 'False') Condition

Result

Condition

-------------

True

See the other example

Select ID,Name, empAdd,  IIF (empAdd='Pune' , 'State : MH',  IIF (empAdd='Patna' , 'State : Bihar', 'Other')),  Mobile FROM [Test].[dbo].[EMP]

See the output