====== Microsoft - Microsoft SQL Server - SQL - Compare - Case Sensitive Comparison ======

===== Binary Checksum =====

<code sql>
SELECT NAME1 , zNAME1 from dbo.ztCusDedup
WHERE BINARY_CHECKSUM(name1)<> BINARY_CHECKSUM(zNAME1) and PARTNER like '%WGW'
</code>

----

===== Collate =====

<code sql>
SELECT NAME1 , zNAME1 from dbo.ztCusDedup
WHERE name1 COLLATE Latin1_General_CS_AS <> zNAME1 COLLATE
Latin1_General_CS_AS and PARTNER like '%WGW' 
</code>

----

===== Cast =====

<code sql>
SELECT NAME1 , zNAME1 from dbo.ztCusDedup
WHERE CAST(NAME1 as varbinary) <> CAST(zNAME1 as varbinary)
and PARTNER like '%WGW'
</code>