How can I change the case of text from upper to title across a SQL DB? - TechRepublic
Question
January 31, 2008 at 07:31 AM
cody.stevenson

How can I change the case of text from upper to title across a SQL DB?

by cody.stevenson . Updated 18 years, 5 months ago

With close to 3/4 of a million rows in the table and no previous standard for data input, I have a SQL DB that is full of UPPER CASE entries. I want to convert them all to Proper or Title case. Is there a T-SQL command that I can execute safely to do this “automagically”? I have looked around but have not found a reliable and viable solution. Thanks in advance for the help!

This discussion is locked

All Comments