Random query---ODBC

[Dankniseley]

HI

I connect to a very large data set through an IDBC connection. Is there a way to run a query that will do the following (SQL Code).

1) return data fields under a WHERE condition and add a data field (random #) like the excel function "=RAND()".

2) sort by the random data field.

3) reurn the top/bottom 300 records

Thus mimicing returning a 300 random records that meet my WHERE clause.


Thanks in advance

Dan