Can anyone explain the logic in this for me??

From: J.P. <jp_boileau_at_yahoo.com>
Date: 1 Mar 2002 12:19:04 -0800
Message-ID: <7e388bc3.0203011219.9e6e569_at_posting.google.com>


Now this is a bit puzzling...

  1* SELECT 'X' FROM DUAL WHERE '' = NULL SQL> / no rows selected

Elapsed: 00:00:00.00
SQL> SELECT 'X' FROM DUAL WHERE '' IS NULL   2 /

'
-
X

Now why is the empty string ( '' ) <> null but the same empty string IS NULL ?

JP Received on Fri Mar 01 2002 - 21:19:04 CET

Original text of this message