In addition, you can combine the first select with DELETE/UPDATE

DELETE MyTable ;
	FROM MyTable ;
	JOIN (SELECT Id FROM MyTable WHERE SomeValue = 1) MyCursor
		ON MyCursor.Id = MyTable.Id

>Thank you!
>
>>In VFP9 only

>>DELETE MyTable;
>>    FROM MyTable;
>>    JOIN MyCursor ON MyCursor.Id = MyTable.Id
>>
>>UPDATE MyTable;
>>    SET SomeField = SomeValue;
>>    FROM MyTable;
>>    JOIN MyCursor ON MyCursor.Id = MyTable.Id
>>

>>