Sql-server – Case-sensitive query – SQL Server 2008

sql-server-2008

How can I rewrite as Latest Developer a record which was created as LATEST DEVELOPER via SQL query?

Best Answer

UPDATE YourTable
SET YourColumn = 'Latest Developer'
WHERE YourColumn COLLATE LATIN1_GENERAL_CS_AS = 'LATEST DEVELOPER'