• Good stuff!

    IIF is supported in Sql Server 2012 and later, my guess to aid portability from Access:-D

    Good luck

    😎