Sybase and random query (SELECT)?

[Anon]

Hi all,
can anybody help me with this:
I am using Sybase and trying to get data from table but every reload to get diferent order
this
SELECT * FROM something WHERE Some_ID=4

will result 5 rows

ID Some_ID Text
5 4 Anything
6 4 Anything
7 4 Anything
9 4 Anything
22 4 Anything

when I try to use this:
SELECT * FROM something WHERE Some_ID=4 ORDER BY RAND()

the result is same! order as well

what I do wrong?
thanks
martin

[Anon]

Hi, I am not familiar with SyBase's version of SQL, but you may need to randomize the seeding of the RAND() function. Perhaps passing it a time() value.

But if you really need to have random ordering, but could not do it with SQL, consider shuffling the results yourself before displaying them.