>The ISBLANK() function IMO is the one that's not working properly.
>
>It works properly on the record by record basis but not in Sql Select.
>

I see that ISBLANK() specifically handles a "blank" logical, so I stand corrected. I agree, if the function is set up to work a certain way, it should work that way across the boards.

>I agree with Craig that the only way to get another value is to have the field be NULL.
>
>Where in my message did I disagree with Craig on this one?

Sorry, I was simply stating that I agreed with Craig, not disagreeing with you.

Tom