Try "... WHERE f IS NULL". SQL is a programming language with three-valued logic, meaning it has truth, falsehood, and null. NULL != NULL, strangely enough.
Nico -- On Jun 3, 2011 8:54 AM, "Paul Sanderson" <sandersonforens...@gmail.com> wrote: > I am sure tihs is basic but..... > > I have a database with a text column and i want to return all rows > where the column has no value > I have tried > select * from db where f = NULL > select * from db where f = "" > select * from db where f = '' > > all return 0 records when I knopw that most fields are empty - what am > I missing? > > Ta > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users