>

select TOP 1000 unemp_ins_pct from payroll_tbl ;
>	where unemp_ins_pct # 0 ;
>	into array a__gen40 ;
>	order by payroll_tbl.id DESC

>
>>I am selecting a bunch of records into and array as follows:
>>
>>

>>select unemp_ins_pct from payroll_tbl
>where unemp_ins_pct # 0
>into array a__gen40
>order by payroll_tbl.id

>>
>>The above select statement gives me all the records in the table. What I would like to know is how can Select only the last 1000 records in the payroll_tbl?
>>


Thanks Sergey. Haven't use foxpro for a while, into .NET now.