>Me again ;-)
>
>Because you asked if a primary key exists: Is there solution whit a primary key without the need to cut the memofield?
>
>Gerhard
>
Yes.
select T.* from Tab1 T inner join (select Field1, Field2, min(PK) as MinPK from Tab1 GROUP BY Field1, Field2) X
ON Tab1.PK = X.MinPK
If it's not broken, fix it until it is.
My Blog