Blank String problems

From: <dean.taplin_at_intrinsic.co.uk>
Date: Mon, 28 Jun 1999 07:55:52 GMT
Message-ID: <7l79q6$b46$1@nnrp1.deja.com>

I have an SQL statement that contains the following criteria:

and V.code1 is not null
and V.code1 <> ''
and V.code1 <> ' '))

On Oracle the above statement returns zero rows. If I remove the second line containing '' so that the SQL now reads:

and V.code1 is not null
and V.code1 <> ' '))

The number of rows returned is no longer zero. Why is this so?

This SQL statement works fine on all other database platforms. For Oracle '' is the same as NULL and since I am testing for '', ' ' and NULL I do not why I am getting different behaviour when I run this SQL statement on Oracle.

Any comments appreciated.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 02:55:52 CDT