Hi Alex,

No matter what checksum routine you use, you won't get a guaranteed unique value for each different record - that's not the purpose of a checksum.

Liam




>Hi everybody,
>
>Wondering if anyone has a function to create a checksum for a WHOLE record in a table.
>
>For example, I have a table that has 128 fields and need a quick way to find duplicate records. I thought about doing a sys(2007) of a couple of fields, but not only I am getting unreliable results (several records that are different are yielding the same checksum) but I now need to compare ALL fields in order to determine uniqueness.
>
>If anyone can share some code or if there's anything already built into vfp, I'd appreciate a pointer...
>
>Thanks a lot!
>
>Alex