>Thanks Sergey,
>
>I'l give that a try. Is there any reason to avoid using iif() in the SQL? I just got in the habit of avoiding that for some reason.
Hi Cris,
I'm with you on this one. I prefer to use whatever options SELECT SQL provides first because Query Optimizer could better optimize query in this case. The second reason, I've had bad experience in using IIF() in WHERE clause when such condition produced totally unexpected and unexplained results.
--sb--