Guys (especially Jooel) my apologies - i'm such a windbag peabrain - in all my ranting i totally lost sight of the fact that IIF is a FUNCTION - not a CONSTRUCT ... of course it would behave this way - just like any other function (builtin or custom) all parameters would be evaluated before the function was entered. It was hard for me to think of IIF as a function (for some reason) ...
Only came to this (obvious?) realization on the train ride home and re-reading jooels earlier comments - Jooel, you should have like threw a book at my head or something to wake me up.
My apologies to Microsoft and Ruud as well.
[ 09. January 2003, 02:26: Message edited by: Shawn ]