>>>What's the differences between nested IIF()'s and ICASE(). From what I can see, there's not
>>>alot of difference syntactically. Are there any performance differences?
>>>
>>>
>>>? ICASE(1 # 1, "One",;
>>> 2 # 2, "Two",;
>>> 3 = 3, "Three")
>>>
>>>? IIF(1 # 1, "One", IIF(2 # 2, "Two", IIF(3 = 3, "Three", "" )))
>>>
>>>
>>>Of course, the ICASE seems more readable than the IIF()'s.
>>
>>Icase is faster and much more radable.
>
>At first I thought so too, but they're both boolean evaluations, so it seems that they would be about the
>same.
I am pretty sure that Icase is faster, but whether the difference is significant or not, I don't know. But the improved readability can be translated into improved maintainability, and that's enough for me. I have been able to tidy up some rally messy code.