I've always considered IIF (in Excel etc.) to be a bit Micky Mouse and that using a function for a logic test offended my programmers sense of "IF THEN ELSE" ... but just reading your comment perhaps I should recast that. ISNULL is doing something similar - choosing a parameter based on the logical outcome of a test - so perhaps I have been unfair to IIF() in the past 🙂