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 ;-)SELECT TRUE FROM dual WHERE NOT 1 <> NULL -> false (!)
perhaps the optimizer is optimizing it to 1=NULL which is false.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
