On Sat, Jun 25, 2011 at 04:55:13PM -0400, Igor Tandetnik scratched on the wall: > logan...@gmail.com wrote: > > How do I check for a null or empty string in SQLite. SQL server has ISNULL > > but it doesn't seem to be supported in SQLite. > > where MyField is null
where MyField isnull is also supported. http://www.sqlite.org/lang_expr.html ("is null" is just a standard "is" with the right side expression being a literal NULL.) -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users