Diane,
Which field is of uniqueidentifier data type?
>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
--sb--