Initially, you might want to clean it up by hand. The best way to
do this is just use a statement like this:
Delete From Calls
Where CallDate < '6/1/98'
and then increment the date up and execute it again. Try and only do small
pieces at a time. Eventually, you can use a statement like this in
SQL Executive (running nightly or weekly) to trim out the records:
Delete From Calls
Where DateDiff(Month, CallDate, GetDate()) > 2
This would delete all records older than 2 months.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com