collation conflict

TheWHERE Clause: Case Sensitivity and Collations

Get all Collation list from below functions.

Select * from fn_helpcollations( )

ResolveCannot Resolve Collation Conflict Error - SQL in Sixty Seconds #047

Solution:

select * from CollateExample ce where ce.Collate1 COLLATE DATABASE_DEFAULT = ce.Collate2 COLLATE DATABASE_DEFAULT

Effectof Collation on Resultset - SQL in Sixty Seconds #026