Re: [sqlite] ISNULL in sqlite

[logan...@gmail.com]

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 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

Re: [sqlite] ISNULL in sqlite

[Gerry Snyder]

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

Re: [sqlite] ISNULL in sqlite

[logan...@gmail.com]

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

Re: [sqlite] ISNULL in sqlite

[Jay A. Kreibich]

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

Re: [sqlite] ISNULL in sqlite

[Igor Tandetnik]

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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ISNULL in sqlite

[Mr. Puneet Kishor]

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]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ISNULL in sqlite

[logan...@gmail.com]

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.

Thanks,
Hitesh
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users