SQL 2005 select results in a random order

Simply use a statement like:

SELECT * FROM foo ORDER BY NEWID()

For equivalents in other SQL databases, see here