[firebird-support] select in random order - HELP

[Luiz]

Hi,

I have a table
T1(id int, name varchar(30))

Sample of data:
Id              name
-----------------
1               abc 
2               def
10              ghi
6               lal
1000            kkk
900             LAL


I´d like a select returning records in random order. Something as:
Select id from t1 order by RANDOM(id)
ID
-----
1
10
2
1000
900
6

Thanks in advance,

Luiz