Thank you everyone!! On Sat, Jun 25, 2011 at 9:27 PM, Jay A. Kreibich <j...@kreibi.ch> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users