Gary,

Try something like this:

SELECT TOP 1 ;
yourField1, yourField2, ;
STR(RAND()*1000000,7,0) AS randseq ;
FROM yourTable ;
IN ResultCursor ;
ORDER BY 3

HTH

George