null? not null?

From: Dave Peckham <davep_at_natinst.com>
Date: 1996/09/04
Message-ID: <322E1968.6CE6_at_natinst.com>#1/1

I can't figure this one out:

select rc_isr from repcode rc_country = '';

No rows selected

This happens even after I set rc_country = ''. However, if I use is null, it finds the record.

I though '' and null were the same.

Any thoughts? (nothing in the FAQ's)

Dave Peckham

IS Programmer/Analyst                           dave.peckham_at_natinst.com
National Instruments                              http://www.natinst.com

Received on Wed Sep 04 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Liu Hui Ting: "SQL*Loader"
Previous message: Sridhar Ramalingam: "Proc*C 2.06 problem"
Next in thread: Scott Urman: "Re: null? not null?"
Reply: Frenchy461: "Re: null? not null?"
Reply: Scott Urman: "Re: null? not null?"
Maybe reply: Struyve Stephane: "Re: null? not null?"
Maybe reply: Rudi Demeulenaere: "Re: null? not null?"
Maybe reply: Rakesh Patel: "Re: null? not null?"
Maybe reply: Rakesh Patel: "Re: null? not null?"
Maybe reply: Rakesh Patel: "Re: null? not null?"

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

Original text of this message