UPDATE tsiPartnerKontakt SET EmailOpomba='eIOP' 
WHERE dbo.Emp(EmailOpomba)=1 AND (dbo.Emp(Email) = 0) AND LEFT(PartnerID,1) IN ('0','1','2','3','4','5','6','7','8','9')

UPDATE tsiPartnerKontakt SET EmailOpomba=EmailOpomba+',eIOP' 
WHERE patindex('%eIOP%',EmailOpomba)=0 AND (dbo.Emp(Email) = 0) AND LEFT(PartnerID,1) IN ('0','1','2','3','4','5','6','7','8','9')