If you don't mind R/O cursor as result than

Select * ;
	From temp ;
	Into Cursor Temp

* The following code will make it R/W again
Use (Dbf("Temp")) Again In 0 Alias Temp1
Use in Temp
Use (Dbf("Temp1")) Again In 0 Alias Temp
Use in Temp1
Select Temp

* Or if you requeire R/W cursor
Select * ;
	From temp ;
	Into Cursor Temp1
Select Temp
Zap
Append From (Dbf("temp1"))
Use in temp1

>Hi Hector
>
>Yes I realize that closing a cursor will get rid of all records but I want to keep the non-deleted records. I also understand that I can copy to another table/cursor or append non-deleted records into another table/cursor but I was wondering if there was one of those magic "one-liners" that Cetin/Vlad/Sergey et al sometimes come up with :)
>
>Thanks
>
>Jos