Ian A. Newby wrote:

> Hi Lester,
> You could try this...
>
> Create a table
>
> create table random (
> mykey integer not null,
> random double precision
> )
> index both fields seperately
> .

Sorry - the reason I've got to match the RAND operator is because this
is a cross database project ( bitweaver! ) and I can change the
structure or add triggers to the many tables that I need a result from.

Ivan - The unsorted random is what I am using now, but it tents to throw
up the same random page as 'pick of the day' every day - not
particularly random - which is why I am trying to craft something that
will fit into ADOdb's sort order selection in some way.

Ideally anything that throws up a different article/blog/product/wiki
etc each time you access a site that is using 'pick of the day' and
similar random displays. I don't use it myself, but it's logged as a bog
against Firebird at present :(

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.