Try wrapping the memo field in a hashing utility like MD5HASH. x = Createobject("MD5srv.aaMD5") SELECT Field1, Field2MEMO, x.MD5String(Field2MEMO) as MemoHash FROM DBF() ORDER BY MemoHash

This will identify all memos that have same hash value (distinct). At this point you can do a subsequent JOIN on only unique hashes or select into another table and create a unique index on memohash to only return unique instances