>>
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.
>
No problem :)
--sb--