Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen: > This is what I have > select * from ticket where Type = 'Line' and Closeddate = ' empty space' > and have tried the following > select * from ticket where Type = 'Line' and Closeddate = 'Null' > select * from ticket where Type = 'Line' and Closeddate = 'NULL' use isNULL(Closedate) instead of Closedate = 'NULL' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php