Trying to exclude blank rows from a query in SQL Posted July 9, 2015 · Edited July 9, 2015 by Coastie 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.
Trying to exclude blank rows from a query
in SQL
Posted · Edited by Coastie
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.