Your question is a little vauge because it doesnt explain how this is used within the context of FileMaker.
In a regular SQL query ( MySQL ) it would be something like:
ORDER BY RAND ()
With that being said, are you trying to do this with ESS? Import ?
thank you for answering my question.
i connected it though jdbc. so i have to write some sql statements to retrieve some records in the servlets.
i found some examples as you mentioned. but i am not quite sure whether it will apply to filemaker.(ms sql, oracle and mysql have their own version)
I havent tried it so I dont know the results, but I would try using it the way I said earlier. Considering FileMaker's fondness to MySQL, I would "guess" that it would perfer a MySQL syntax SQL statement.
I tried, and it didn't work.
But thank you all the same.