Re: a ramdom sort select

In a similar vein to the other suggestions, but without a stored procedure, if you are using 4GL, you could write a "seed" and "random" C function, link them into your program (or runner), then, in a loop, select each record with a cursor and grab a random number, insert it all into a temp table, then after that is populated, do a select from the temp table, ordered by the random number. hth Daniel Esquerre Fernandez wrote: > > Hi > > Anyone know how make a select of many rows y random order, i e some > like select * from mytable order by random > > Daniel Esquerre F > Jefe de Soporte T'cnico > Org. San Ignacio de Loyola > -- Colin