SQL supports case sensitivity

Use Dc_cecdg

Select   Top   10   *   From Msked_partstotal



Select   Count ( 1 ) From Msked_partstotal
Inner   Join Stock B On A. part_no = B. part_no
Where A. part_no <> B. part_no collate chinese_prc_cs_ai_ws
-- Where cast (A. part_no as varbinary) <> cast (B. part_no as varbinary)


Update Msked_partstotal Set Part_no = B. part_no
From Msked_partstotal
Inner   Join Stock B On A. part_no = B. part_no
Where A. part_no <> B. part_no collate chinese_prc_cs_ai_ws

/**/ /* 
The CI parameter is case insensitive and the CS parameter is case sensitive.
AI specifies no accent, and as specifies the accent.
Omitted specifies case-insensitive, and WS specifies case-sensitive.
*/