"Helen Borrie">

> >Is there a way to delete at one stretch the records in a gdb pertaining

to

> >say date '01-APR-2001'? Now i have to remove the constraints like foriegn
> >key for each table and then delete using Sql statement.

> DELETE FROM ATABLE
> WHERE Mydate between '01-APR-2001' and '02-APR-2001' ;

Won't ths get rid of 02-apr-2001 00:00:00 as well, I thought between was
inclusive.

JAC.