| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: Character Equality
Caffeine wrote:
>
> Hi there,
> Just wondering if any one can explain to me why the following
> statement returns no rows.
>
> select test from tmp4 where test != '';
'' is equivalent to NULL, and you cannot do equality comparisons with NULL, instead do:
select test from tmp4 where test IS NOT NULL; Received on Tue Sep 12 2000 - 12:30:24 CDT
 |
 |