Hi,
I'm trying to run a query that will exclude all the rows that have nothing listed in a particular field. The default value for the field in question is None and it is a text field.
If I try IS NOT NULL I get all of the rows.
If I do IS NULL I get no rows
If I try = None I get no rows
So I'm at a loss as to what to do next.
Any help would be appreciated.