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
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,
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 SQLi
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
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.or
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_c
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
7 matches
Mail list logo