How would the entire query look select * from ticket where Type = 'Phone' and ??????? "Dirk Kredler" <dirk@computication.net> wrote in message 200307221129.59337.dirk@computication.net">news:200307221129.59337.dirk@computication.net... > 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
