SQLite: Find NOT NULL empty records

-- find NOT NULL empty records

SELECT COUNT(*) FROM big_list WHERE pubchem_cid IS NULL OR trim(pubchem_cid) ="";

"Sometimes you eat the bear, and sometimes, well, he eats you."