NULL is not equal to anything, including itself. ('' = NULL) is false,
(NULL = NULL) is also false. To test for NULL, use IS NULL, such as :
SELECT * FROM t WHERE (LastName = '' OR LastName IS NULL) AND (Name =
'Peter')
-----Original Message-----
From: Daniel Schumann [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 26, 2006 2:52 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] SELECT on empty fields ??
Hello,
i got a table 't' with two fields for example :
Lastname | Name
---------------------------------
Duck | Donald
| Peter
with :
SELECT * FROM t WHERE (Lastname='Duck') AND (Name='Donald')
everything is all right
with :
SELECT * FROM t WHERE (Lastname='') AND (Name='Peter')
or
SELECT * FROM t WHERE (Lastname=NULL) AND (Name='Peter')
nothing is selected
what do i wrong ?
thx
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
