>i forgot to mention that there are certain fields that i want to exclude from the comparison.

Jeffrey,
Are you doing this against the whole table at once, or only checking records as they are accessed, or what do you need it for? If it is whole table at once, I would use the solution posted by Nadya Nosonovsky, it is much quicker for comparing whole tables, and you can exclude fields from the field list if you want to. Good luck,
John