--- In firebird-support@yahoogroups.com, "Svend Meyland Nicolaisen"
<news@...> wrote:

>
> Eh, is this what you want?
>
> Select first 6 Word_No
> from DownLoad
> Where Used = 'F'
> Order By Word_No
>
> /Svend
> ________________________________

Hi Svend

Thanks for the response.
Not quite, I need a group of "Word_No"'s that are cconsecutive
e.g.
All these are Used = 'F'
3, 4, 11,12,13,14,15,16,17,23,24,25
I want the query to return 11,12,13,14,15,16

Regards

Jack