Delete all vendors for whom there are no transactions

can any one help me please

try

IF Vendor.FINDSET THEN REPEAT

VendorLedgerEntry.SETRANGE(“Vendor No.”,Vendor.“No.”);

IF NOT VendorLedgerEntry.FINDFIRST THEN

BEGIN

vendor1.RESET;

vendor1.SETRANGE(vendor1.“No.”,Vendor.“No.”);

IF vendor1.FINDFIRST THEN

vendor1.DELETE;

END;

UNTIL Vendor.NEXT=0;

I suggest don’t delete the master just blocked them as in future there will be transaction for those vendor.

Just think again before deleting the master…

i created a table with the fields of

number,name,emailid

i have entered the values

number name emailid

1 x x@gmail.com

2 y y@gmail.com

i created a table with the fields of

number,name,emailid

i have entered the values

number name emailid

1 x x@gmail.com

2 y y@gmail.com

3 z zgmail.com

4 a agmail.com

where we can find above table containing values in the emailid field ,some of the fields which consist @ ,and some are not

at this point of view about my question is

list all email ids which don’t have @ symbol and delete them

i have gone through the strposition function where this function could helpful for knowing the string position of @ symbol

can you please help me