Does anyone know why I would be receiving the following error when
running the below script?

Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.

The script looks like this...

SELECT
rtrim(a.UpcStyle),
rtrim(b.color_code)
FROM
ccsi.dbo.upccode a,
upc_entry.dbo.upc_rec b
WHERE
b.style_code=a.UpcStyle
AND a.UpcColor=b.color_code

Thanks!

Sean


MS Sql Server LazyDBA home page