hi there, i've just tried the following: SELECT whatever FROM table WHERE column <> '1' revealing that no rows are returned that have column=NULL.
Defenitly it's simple to work-around with an "OR IS NULL", but im quite unsure how this fits. My way to come was "everything is other than '1' except '1', therefore an undefined value is also other than '1'". i may be wrong (and it seems i am - the hours to figure that out speak for themselfs), so, somebody can give a hint what's truth about? best regards, Mario Oberrauch _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
