>>Add NOFILTER.
>>
>>>The following selects all the records and puts them into a cursor. About half the records are deleted and I see the deleted mark
>>>
>>>SELECT * FROM obligor INTO CURSOR aa
>>>
>>>The following selects all the records with name > 'C' and the deleted records are no longer marked for deletion. WHY? I am doing these two SQL statments back to back in the command window.
>>>
>>>SELECT * FROM obligor INTO CURSOR aa WHERE name > 'C' ORDER BY name
>>>
>>>Thanks
>>>
>>>Brenda
>
>Does the NOFILTER only affected the deletion mark?
>
>Brenda

It creates real cursor instead of filterd table. Try

SELECT * FROM obligor INTO CURSOR aa
? DBF()
? FILTER()

SELECT * FROM obligor INTO CURSOR aa NOFILTER
? DBF()
? FILTER()