Quote from BurrKing_Mfg on 04/20/15 at 06:05:54:.....
I have some garbage that has been created over the years in the old contact manager that still is showing up in grids that I need to clean up.
Same situation here. This is what we used to clean up our contacts.
'No Customer Code DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;
'It is not a Primary Record, No Contact, and No Email DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_PRIM))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_EMAIL_1))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_CON))) = 0;
'Delete some weird records DELETE FROM BKCMACCN WHERE BKCM_ACCN_EMAIL_1 = '.F.';"
If you change the "DELETE " to "SELECT * ", you can see what records will be delete.
Good Luck
Kelloggs