>>Which is what I expected
>>
>>If the expr is null it takes the else part of the iif()
>>
>Great thought about NULL.
Yep, but NULL is nether .T. neither .F.
I would use NVL() instead of IIF() :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.