With an IIF function, we largely replace a lot of the syntactical sugar from the CASE statement with a few simple comma-seperators to differentiate our arguments. All told, both CASE and IIF get the same job done, but if given the choice, IIF will generally be much simpler to use.