>I have a table with normal record an erased record. The is a way to get only the erased record in a select command ???
Yes, you can put SET DELETED OFF, and then
select ... where deleted()
However, you should not do this on a regular basis. A deleted record should be considered as "gone" - either you keep a record, or you delete it. If you need to keep a record (for example, a financial transaction), have a separate field called, for instance, "cancelled".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)