sql server mseq: Is there a way ORDER BY clause can randomize the order of rows returned?

eg:
SELECT column1
FROM table1
ORDER BY column1 ASC

Here instead of ASC or DESC, I want the order to be random.

Is there is anyother way to do this if not possible by ORDER BY?

Thanks.

In t-SQL, though not recommended & undocumented, you can do:

ORDER BY New_Id()

If you have a unique key column, you can also do:

ORDER BY RAND((@@IDLE % keycol) +
DATEPART(ms, CURRENT_TIMESTAMP) + keycol)

--
- Anith
( Please reply to newsgroups only )

A typo: it should be NEWID() --- no underscore.

--
- Anith
( Please reply to newsgroups only )

Thanks Anith, that worked.


[quoted text, click to view]