'hello world' != '' does not work?

From: Jeffrey Boulier <jeffreyb_at_gwu.edu>
Date: Fri, 16 Mar 2001 23:21:53 GMT
Message-ID: <lexs6.1655$AS6.8322@grover.nit.gwu.edu>

Hi folks,

        We're running into a strange problem with != . It works for numerics, but not for strings.

produser_at_PROM> select sysdate from dual where 1 != 0;

SYSDATE

---

16-MAR-01 user_at_DB> select sysdate from dual where 'hello world' != '';

no rows selected

Any thoughts? Is != not valid for comparing strings in Oracle, or have we run into a bug? Our database is 8.1.6.3.                         

			Yours Truly,
			Jeffrey Boulier

-- 
Community Source & Support  


------=>Prometheus<=------

Received on Fri Mar 16 2001 - 17:21:53 CST