Terry,
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--