You can save your self a lot of grief by declaring all of your fields to be NOT NULL and default the text fields to the empty string, ''. Use '' rather than NULL when you don't have a name. Then you can simply say "where foo=''". -- Darren Duncan

At 10:52 PM +0100 11/26/06, Daniel Schumann wrote:
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]
-----------------------------------------------------------------------------

Reply via email to