🚀 go-pugleaf

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