Case-sensitive query - SQL Server 2008 How can I rewrite as Latest Developer a record which was created as LATEST DEVELOPER via SQL query?
UPDATE YourTable
SET YourColumn = 'Latest Developer'
WHERE YourColumn COLLATE LATIN1_GENERAL_CS_AS = 'LATEST DEVELOPER'