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