>>>Which is what I expected
>>>
>>>If the expr is null it takes the else part of the iif()
Perhaps indicating that the IIF() is the wrong function for this job and icase() should be used instead
>>>
>>Great thought about NULL.
>
>I have enjoyed reading the comments - the guy who wrote this was a stupid programmer