How can I rewrite as Latest Developer a record which was created as LATEST DEVELOPER via SQL query?
-
Any SELECTs or comparisons involved? is this a one off request? if not, what does your data look like generally?– gbnSep 25, 2011 at 11:46
-
I'm with @gbn. Can you clarify what exactly you are trying to do? Do you just want to update a value to have a different case? How are you going to query this data (does that even matter to you)? Please edit your question with the answers.– Nick ChammasSep 26, 2011 at 23:05
Add a comment
|
2 Answers
UPDATE YourTable
SET YourColumn = 'Latest Developer'
WHERE YourColumn COLLATE LATIN1_GENERAL_CS_AS = 'LATEST DEVELOPER'
If I understand correctly you want to convert strings to "Title Case" - in which case you can write a udf to do this and use it in an update
statement.
-
2