Appreciate that IIF is new in 2012, just with it being in a 2008 forum, I automatically assumed IIF = SSRS IIF not a SQL IIF.

Hence why it is always best to put topics in the right forum for the version of SQL your running as you say, saves on the confusion.

Also personally, I like CASE better than IIF, as I find nested IIF's can get a bit messy, where as CASE is easy to read.