From: "t_wright_1973" <tom@...>

> Hi,
> Using firebird server running on a linux server, not sure what version but
> <2.1.
> The client is iSQL using unix ODBC.
>
> Can anyone explain what is happening to TEST_NO in the two statements
> below?
>

If I had to guess, I'd say that FIRST means nothing without an ORDER BY
clause. Results are more or less random at that point and you could get
anything, mostly by record order in the database, but not for certain.

Woody (TMW)