• Drew points out that the CASE statement allows for more than 2 conditions which is a good thing to have in place for future expansion.

    I also believe that SQL evaluates IIF into a CASE statement anyway so why not give the server a break and write it as a CASE statement in the first place?

    If you can't tell I'm not a fan of IIF. I like the more verbose CASE.