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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 5 down vote accepted
UPDATE YourTable
SET YourColumn = 'Latest Developer'
share|improve this answer

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


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.