Cannot resolve the collation conflict between "SQL_Latin1_General_CP1

Error:

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Query:--

SELECT c.clientid, c.groupno, c.flexid, c.deduct, c.sdate, c.edate, c.active, UPPER(c.addr1),

c.addr2, c.autoroll, UPPER(c.pcode), UPPER(c.city), c.phone, c.copay, c.employee, c.cob, l.locn, UPPER(f.descr),

c.pa, c.psa, c.family_amount, UPPER(c.ext_cob_desc), l.locn , UPPER(l.descr), c.flexid , c.coverage,

c.create_date, c.create_userid, c.update_date,c.update_userid, c.ext_cob, c.deduct, c.notes, c.sin,

c.create_app_name, convert(VARCHAR(10),c.create_data_file_date, 120),

c.update_app_name, convert(VARCHAR(10),c.update_data_file_date, 120),

c.province FROM [MHCSI].[CLIENT] c LEFT JOIN [MHCSI].[LOCATION] l on c.locn = l.locn AND l.groupno = c.groupno

LEFT JOIN flex_plan on f.flexid = c.flexid AND f.groupno = c.groupno WHERE c.clientid = '0000000088'

AND c.groupno = '0000080039' ORDER BY c.pcode

1 Reply

Know the answer? Post it — somebody with the same question will find it here.