Re: [sqlite] SELECT queries and NULL value parameters

you can also use ifnull(myvar1,'') = ifnull(myvar2,'') or something in the same way. I used it for avoiding creating 2 queries for each cases. Cheers, Sylvain On Wed, Mar 11, 2009 at 4:14 PM, Jim Wilcoxson wrote: > I used the Solid database for many years, since they came

Re: [sqlite] SELECT queries and NULL value parameters

mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Martin Engelschalk > Sent: Wednesday, March 11, 2009 8:59 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SELECT queries and NULL value parameters > > Hi, > > yes, this is expected. Note that you use the =

Re: [sqlite] SELECT queries and NULL value parameters

oun...@sqlite.org] On Behalf Of Martin Engelschalk > Sent: Wednesday, March 11, 2009 8:59 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SELECT queries and NULL value parameters > > Hi, > > yes, this is expected. Note that you use the = - operat

Re: [sqlite] SELECT queries and NULL value parameters

AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SELECT queries and NULL value parameters Hi, yes, this is expected. Note that you use the = - operator in WHERE maybenullcolumn = @value and NULL = NULL evaluates to false. This is SQL standard. Martin diego.d...@bentley.com wr