RE: a ramdom sort select

Someone recently posted a stored procedure that returned a random number (I don't think I dreamed this...). You should be able to do: select random(), field_list from whatever order by 1 -----Original Message----- From: Daniel Esquerre Fernandez [mailto:desquerre@sil.edu.pe] Sent: Wednesday, April 26, 2000 1:33 PM Posted To: informix Conversation: a ramdom sort select Subject: a ramdom sort select 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