Re: SQL IF

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/06/13
Message-ID: <skduqnniis493_at_corp.supernews.com>#1/1

[Quoted] "Jack Ostroff" <jack_h_ostroff_at_groton.pfizer.com> wrote in message news:394651B4.681C4226_at_groton.pfizer.com...
>Other readers have pointed out that NULL fails both = and <> tests.

Yes. Oracle decides to treat nulls as "I don't know what to do with it" in [Quoted] these kinds of tests. It's kinda annoying but I can sort of understand why.

-Matt Received on Tue Jun 13 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: times9_at_my-deja.com: "Re: INSERT INTO and MULTI-RECORD Pls Help!"
Maybe in reply to: Christina: "Re: SQL IF"
In reply to Jack Ostroff: "Re: SQL IF"
Next in thread: times9_at_my-deja.com: "Re: INSERT INTO and MULTI-RECORD Pls Help!"
Reply: Mike Dwyer: "Re: SQL IF"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message