select * from news where sysdate > expiration_date and approved_p = 't' order by release_date desc, creation_date desc" In this case, one line would be the better, of course. -- Peter Tury, June 12, 2002