DELETE from agent_master where agentcode not in (
select agentcode from agent_master where right(agentname,1)='*' ) and AGENTCODE <>'-DIRECT'