String matching with data in SQL server using COLLATE
update CLEAN.Product_Ref set laboratories_Clean = UPPER(laboratories_Clean)
where LOCAL_PACK_ID in
(select LOCAL_PACK_ID from CLEAN.Product_Ref
where laboratories_Clean != UPPER(laboratories_Clean) collate Latin1_General_CS_AI)
