Posted onFebruary 25, 2011 by Josephine Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. update query like this: WHERE a.lastname COLLATE Latin1_General_CI_AS = k.lastname