Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Problem: Like-Statement and NULL-Fields
Hi,
I try to get a recordset with the following statement:
SELECT * FROM Users WHERE Flags NOT LIKE 'D%';
The Problem ist, that I don't get a row if the Flags-column in this row is NULL. Even if I set the Flags-value of a row to '' (double ') Oracle turn's this to NULL. If I define the Flags-column with NOT NULL I always have to set this value. Trying to set a Default-Value failed.
I can't change the SELECT-Statement but I'm able to change the table-definition. How can I get rid of this problem?
Thank you,
Volker Received on Tue Oct 22 2002 - 01:31:13 CDT