Hi, we've had similar problems with collations across different data sources, but have also found one bonus. As part of the validation for data imports we check for personal info being in upper case by using a case sensitive collation

--Does the data need to be proper cased

select 'Employee- ' +d.EMP_REF+ ' name- ' +d.SURNAME

from DOWNLOAD_Employee d

where substring(d.SURNAME, 2, 1) --get second character in SURNAME

<> lower(substring(d.SURNAME, 2, 1)) --get second character again and lowercase it

collate sql_latin1_general_cp1_cs_as --compare the two using a case-sensitive collation