I can't figure out why this SQL statement isn't working - it returns the same value every time.
SELECT Field1 FROM Table1 ORDER BY rnd()
I also tried
SELECT Field1 FROM Table1 ORDER BY rnd(NumericValue)
It returns the same result every time as well (not the same result as the first SQL statement, but the same one everytime the query is run.)
Any help would be appreciated.