hi, how can check in select command if bdate field is empty. i try SELECT CUSTOMER WHERE bdate='0000-00-00'; that's not success . i am sure i have record without value in bdate field thanks zuhear -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php