"very likely to be unique" always worries me. My experience is you eventually get in trouble.
>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
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
