1

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

2
  • Any SELECTs or comparisons involved? is this a one off request? if not, what does your data look like generally?
    – gbn
    Sep 25 '11 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. Sep 26 '11 at 23:05
5
UPDATE YourTable
SET YourColumn = 'Latest Developer'
WHERE YourColumn COLLATE LATIN1_GENERAL_CS_AS = 'LATEST DEVELOPER'
2

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.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.