>Hello all
> i have a table ,i want to delete a limited number of records after i make
>filter .e.i if have team_no=4 ,when i make filter to this team_no i got 100 records ,i want to delete 25 record or 40 etc....
>
>i write set filter to team_no=4 how i can make filter to 25 frm 100 etc....

I think you mean how to set filter not delete.

thisform.addproperty('aFiltered[1]',0)
select top 25 ;
   recno() as rcno ;
   from myTable ;
   where team_no = 4 ;
   order by 1 ;
   into array thisform.aFiltered
set filter to ascan(thisform.aFiltered, recno()) > 0

Cetin