[AccessD] Looping through table Fields

I tried this in the SQL list but now response.

I have an SQL2000 database that we require to compare two records 
field by field and report back on the fields that have different values.

Can someone please point me in the right direction of how to do this 
within a stored procedure?

I know I could hard code each field but the full project has several 
tables with over 400 fields.  I would rather lop through a fields 
collection to do the comparison.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand