"Helen Borrie" <helebor@...> wrote in message
news:<5.2.0.9.2.20031027145726.0ba90a38@...>...

> At 09:33 PM 26/10/2003 -0600, you wrote:
>
> It's not IBO, it's standard SQL. Null isn't a value, so it can't be
> "equal" or "not equal" to anything, not even null. If you want to include
> or exclude null in a search condition, you always have to do so
> specifically, using "is [not] null".
>
> Helen

Ok. This happened in my conversion from DBISAM. DBISAM worked the other
way but I guess it isn't following the standard then.

Thanks.

_________________________________________
Don Gollahon
ICQ#: 115831669
"What in Eternity does it matter?"
_________________________________________