Using the TSQL IIF Function
Here is a quick video tutorial on how to use the IIF function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the sample code from the video. More Info: Additional Training on my YouTube Channel Free SQL Query Training