Eh, is this what you want?

Select first 6 Word_No
from DownLoad
Where Used = 'F'
Order By Word_No

/Svend
________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of jackmills75
Sent: 10. januar 2008 12:11
To: firebird-support@yahoogroups.com
Subject: [firebird-support] SQL Help



How to return the 1st group of consecutive records that match the
criteria

i.e. in english

Select first(6) Word_No from DownLoad
Where Used = 'F' and Word_No's are consecutive
Order By Word_No

Word_No's values are 0 through 65000

using firebird 1.5

Thanks for any help

Jack