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

Reply via email to