How would the entire query look select * from ticket where Type = 'Phone' and ??????? "Dirk Kredler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
