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
Diane Robitaille eng.