Thank you very much,
I will add a primary key and be happy!
Gerhard
>>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
Gerhard Schmidbauer
URANUS Software GmbH