select blah from tab where col is not null; (which because of your
constraint would be equivalent to select blah from tab )
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Alexander Lang" <lang_at_mueritz-comp.de> wrote in message
news:3CDF9F50.83CCF990_at_mueritz-comp.de...
> Sorry,
>
> but how can I workaround it?
>
> Thanks,
> Alexander Lang
>
>
> "Vladimir M. Zakharychev" schrieb:
> >
> > This is a FAQ: in Oracle, '' (empty string) is NULL and should be worked
with
> > as such.
> >
> > --
> > Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> > Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> > All opinions are mine and do not necessarily go in line with those of my
employer.
> >
> > "Alexander Lang" <lang_at_mueritz-comp.de> wrote in message
news:3CDF8D5C.5F3FEFA8_at_mueritz-comp.de...
> > > Hi NG,
> > >
> > > I use Oracle 8i.
> > > I have a table with a field of type VARCHAR2(8), say A.
> > >
> > > When I use the query SELECT * FROM table WHERE A <> 'foo'
> > > I get a lot of records.
> > > The contents of field A is not NULL and not empty ('').
> > >
> > > When I try the query SELECT * FROM table WHERE A <> ''
> > > I get no records. But there are many records where A is not empty.
> > >
> > >
> > > Can anyone please help me?
> > >
> > > Thanks,
> > > Alexander Lang
Received on Mon May 13 2002 - 06:57:25 CDT
