2011/5/4 Tom Wright <tom@...>:

> Thanks Woody,
> Sadly it's nothing so simple, adding an ORDER BY cause doesn't change
> anything

it should
and as said Woody

> FIRST means nothing without an ORDER BY clause

SELECT FIRST 10 TEST_NO, SUBJECT_NO FROM TESTS ORDER BY 1
or
SELECT FIRST 10 TEST_NO, SUBJECT_NO FROM TESTS ORDER BY TEST_NO

or

SELECT FIRST 10 TEST_NO, SUBJECT_NO FROM TESTS ORDER BY 2
or
SELECT FIRST 10 TEST_NO, SUBJECT_NO FROM TESTS ORDER BY SUBJECT_NO

and why ODBC ?
Firebird version ?