Yeah, but YOU'RE on the ball ... and you can't have been awake long! I make it as only c 7:30 chez toi!
>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.