Re: [sqlite] ISNULL in sqlite

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 wrote: > On 6/25/2011 12:33 PM, logan...@gmail.com wrote: > > Hello, > > > > How do I

Re: [sqlite] ISNULL in sqlite

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,

Re: [sqlite] ISNULL in sqlite

Thank you everyone!! On Sat, Jun 25, 2011 at 9:27 PM, Jay A. Kreibich 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 > > >

Re: [sqlite] ISNULL in sqlite

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

Re: [sqlite] ISNULL in sqlite

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 -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] ISNULL in sqlite

On Jun 25, 2011, at 3:33 PM, logan...@gmail.com wrote: > Hello, > > 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. ifnull() and nullif() [http://www.sqlite.org/lang_corefunc.html]