Thanks Saurabh,
Thats how I finally manage to accomplish the desired output:
set p.vphone = CONVERT(varchar(100), CAST(fp.phone AS decimal(38,0)))
from PMPAXFT P join cmdlhrdev117.drkhandb.dbo.finalplans FP
on p.VURL = fp.planskey
and p.vphone is not null
and...