I haven't catched the argument you used.SELECT TRUE FROM dual WHERE NOT 1 <> NULL -> false (!)
This is strange, and this looks like a bug to me because the NOT should invert the result of 1<>NULL which is in fact false - and NOT false is true ;-)
The dreaded three valued logic monster rears it's head again: 1 <> NULL => NULL NOT NULL => NULL
What do you mean with NOT NULL => NULL?
NULL isn't inverted, it's 1<>NULL which is inverted.
what about NOT (1<>NULL) ?
it doesn't work either, but the brackets should cause, that 1<>NULL is evaluated first.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
