Create view LProva as

(

Select distinct c.[cust.id], a.sms, b.email from

(Select [cust.id], [cust.contactemail]  sms from Prova where [cust.contacttype] = 'sms' ) a,

(Select [cust.id], [cust.contactemail] email from Prova where [cust.contacttype] = 'email'...

Hi Arthur!

What dou you think about this one?

If Telephone is null or PHONET is not null

Begin

 Update TELEMATCHOUT

 Set Telephone = AreacodeT+PhoneT

End