Yes, I'm checking for empty string, but it wasn't working for null. The suggestions by kind people here helped resolve it. Thank you!
On Mon, Jun 27, 2011 at 11:16 AM, Gerry Snyder <mesmerizer...@gmail.com>wrote: > On 6/25/2011 12:33 PM, logan...@gmail.com wrote: > > Hello, > > > > How do I check for a null or empty string in SQLite. > > In addition to the other replies you have received, you need to be made > aware that an empty string and a NULL are very different, and (perhaps) > both have to be checked for, depending on how the data gor into the table. > > > Gerry > _______________________________________________ > 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