Padders: Thank you very much! I test the script, it seems it worked.

One more question: How can select a from date_table where full_date='11/30/2004'? full_date column datatype is date.

I really appreciate your help!