🚀 go-pugleaf

David Madison wrote:
> 
> Eryk Bottomley wrote:
> >
> > David,
> >
> > >How do I create a SQL statement to NOT select fields that are blank.  It
> > >is a character field, and when I try select * from mdbf for mfield IS
> > >NOT NULL, I still get rows that contain the blank field in my result
> > >rowset.
> >
> > SELECT * FROM MYTABLE WHERE (MYFIELD IS NOT NULL)
> >
> > ...is standard SQL syntax.
> >
> > >How do I achieve the equivalient of a unique index, to eliminate
> > >duplicates in my rowset?  I have a unique index available, so do I
> >
> > SELECT DISTINCT .....blah
> >
> > Eryk
> 
> Thanks, I'll give these a try.
> 
> --David

Eryk,

I tried this with my table which has two fields.  When I include both
fields, it doesn't work, ie it includes blank fields in the field I have
asked for IS NOT NULL.

When I remove the second field from the select statement, it works!

Is something broken?

--David