Thanks Jeffrey,

I didn't have time to do all the comparisons as the client was waiting on the system to work properly again. So, I found some software called ApexSQL...

Thanks to you both for your input. I have used J-F's solution for no other reason than I understand it.

The sample tables that I provided were just that -...

That's great, it works perfectly.

Thanks again!

Dave

It doesn't matter which row is eliminated in this case because I'll really only be using the FilePath and FileName from the returned results, which will be the same on...