Tell me more ×
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.
up vote 1 down vote favorite

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

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
up vote 2 down vote

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

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.