>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?

>Of course, the ICASE seems more readable than the IIF()'s.
not only that, it is faster. In "normal" code the difference is not great, but in thight loops and especially in SQL queries working on a couple of milion rows you strive for as much "logic" to put into the smallest amount of memory (cpu cache) and here ICase is much better as well AFAIR.

HTH

thomas