SELECT * FROM Temp WHERE OrderMain>0 INTO CURSOR TempForum SELECT NoClient,MAX(OrderMain) AS SortOrder FROM TempForum GROUP BY NoClient ORDER BY SortOrder INTO CURSOR Temp2So, basically, I had to select all records having a value in OrderMain into a cursor. Then, from that cursor, your command is working.