havent gotten a chance to test your replies yet guy but thank you. i
should be able to test them tomorrow. is there a way to do all this
within sql script? this will run using an automated process so i need
to eliminate the number of steps anywhere i can.