I am trying to create a sql select statement that pulls out records in a random order and then I would like to display them in that random order.

Any suggestion on the select statement and the actuall code to display would be vastly apreciated.

Kind Regards,
Hakan