Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
    
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. –  Nick Chammas Sep 26 '11 at 23:05
add comment

2 Answers

up vote 5 down vote accepted
UPDATE YourTable
SET YourColumn = 'Latest Developer'
WHERE YourColumn COLLATE LATIN1_GENERAL_CS_AS = 'LATEST DEVELOPER'
share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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