select *, isnull(vendeurs.cVendID,space(10)) as cVendeur from JobH left join vendeurs on JobH.cVendId = CAST(Vendeurs.nID AS CHAR(36))