Thanks a lot Mike... what's a clear explanation... Actually I have used WHERE crea_dt + interval 1 day < curdate() before I read ur reply ...but now I guess I better change it to WHERE crea_dt>curdate-interval 1 day
again thanks a lot... and thanks to Jeff too. Sukanto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]