I'm using FB 1.5 RC6. I have a field that is usually null. The following
query does not work:

Select *
from table
where
field1 = somevalue
and fieldNull <> 'EX'

I have to do the following to make it work

Select *
from table
where
field1 = somevalue
and (fieldNull <> 'EX' or fieldNull is not null)

Why doesn't the first query work? Null <> 'EX' so it should.

IBO 4.2.Hf

Thanks.

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