I'm trying to limit the results where a datatime field is later than todays date: WHERE TO_DAYS(NOW())>TO_DAYS(MyTable.myfield) doesn't appear to work. Should it? Should I not be nesting functions within an SQL statement like this? Thanks in advance for any ideas. John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php