>"very likely to be unique" always worries me. My experience is you eventually get in trouble.
>
True. And on an afterthought - I don't see why we cannot use a pk - valid for the lifetime of the query - using a derived table
select * ;
from ( select recno() as pk, ;
Test.* ;
from Test ;
) X
>>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
>>
Gregory