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