am facut asa pana la urma

select distinct A.LeadID,A.CompanyName from LeadBase A
join  LeadBase B on A.CompanyName = B.CompanyName and A.LeadID <> B.LeadID and A.statecode = 0  and A.deletionstatecode = 0 and B.statecode = 0 and B.deletionstatecode = 0
where A.Companyname is not null
order by A.CompanyName asc

sunt sigur ca exista si o varianta mai simpla(a ta....dar cu niste conditii in plus)....dar sper macar asta sa fie buna....si pe urma o modific pe a ta

multumesc mult.

alex.