Character Equality

From: Caffeine <danny_milne_at_yahoo.co.uk>
Date: Tue, 12 Sep 2000 16:55:44 GMT
Message-ID: <8pln62$sim$1@nnrp1.deja.com>

Hi there,

Just wondering if any one can explain to me why the following statement returns no rows.

select test from tmp4 where test != '';

The table contains...

SQL> select * from tmp4;

TEST

HELLO
Hello
hello

The table is described as...

SQL> desc tmp4;

 Name                                      Null?    Type
 ----------------------------------------- ----------------------------
 TEST                                               VARCHAR2(10)

And the results of a similar query. (Looking for NOT a single space) SQL> select test from tmp4 where test != ' ';

TEST

HELLO
Hello
hello

I'm running Oracle 8.1.6 on RH Linux 6.1 and I'm stumped. Any ideas? Thanks for your time...

Dan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 11:55:44 CDT