Hi everyones,

I'm sending this statement to SQL

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

When JobH.cVendID is empty I get error :
Server: Msg 8169, Level 16, State 2, Line 1
Syntax error converting from a character string to uniqueidentifier.

I know cVendID can be empty that's why I'm doing a left join not an inner join! Anything I can do?

TIA