>Woud this work?

<pre>SELECT Numero, MAX(OrderMain) SortOrd FROM Temp ;
>GROUP BY Numero ;
>ORDER BY SortOrd ;
>INTO CURSOR Temp2

If it doesn't, can you provide more info about data you're processing and result you want.

No, because the key in production is:

   INDEX ON STR(OrderMain)+STR(NoCat)+STR(NoThread)+STR(NoParent) TAG OrderMain

I simply simulated the bug by using a more simpler SQL.