db(db.table.field == None).select() should give you all records with field = NULL
db(~db.table.field == None).select() All records where field <> NULL Is that? --
db(db.table.field == None).select() should give you all records with field = NULL
db(~db.table.field == None).select() All records where field <> NULL Is that? --