>>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

You can make a sort of PK - two fields together

PartOne + PartTwo is an expression that is very likely to be unique

	select cast(sys(2007, F5, 0, 1) as B(0)) as PartOne, ;
			padr(F5, 200) as PartTwo, ;
			count(*) ;
		from test ;
		group by 1, 2