Hi All,

I would like to use SELECT command to search only in one table (DBF).
Could anyone help me with some codes ?

TableEx.dbf contained three fields :

IDNUMBER DATE CODE

11111 01/01/01
11111 01/02/01 X
11111 01/03/01
11111 01/04/01
22222 01/01/01
22222 01/02/01
22222 01/03/01
22222 01/04/01
33333 01/01/01
33333 01/02/01
33333 01/03/01 Y
33333 01/04/01

after used SELECT and DELETE, I should have only one IDNUMBER
left in the TABLEEX.DBF means every IDNUMBER who had no blank CODE
should be deleted from the table.

22222 01/01/01
22222 01/02/01
22222 01/03/01
22222 01/04/01

Thanks in advance,
Paul