You could blame it on Monday. :)
>Oh, yes - not reading the SQL fully enough :-)
>
>>
>>The sort order is DESCending.
>>>
>>>Could you please clarify for me how your soln. gets the LAST 1000 recs? I'd've thought that this would get the FIRST 1000 recs in the criteria.
>>>
>>>Terry
>>>
>>>>
select TOP 1000 unemp_ins_pct from payroll_tbl ;
>>>> where unemp_ins_pct # 0 ;
>>>> into array a__gen40 ;
>>>> order by payroll_tbl.id DESC
--sb--