Coverting Name to the same case

I have a file that has a mixture of data input. Some of the data is all upper case and some of the data has the first letter as upper case and the rest as lower case.

Is there a way to uniform the data.  My preference is converting it all to First letter Upper case and the rest lower case.
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Kent DyerConnect With a Mentor IT Security Analyst SeniorCommented:
Couple of different approaches..

UPDATE SOMETABLE SET SOMEFIELD=LOWER(SOMEFIELD)

Here is one with the Init Caps..

http://dbaspot.com/sqlserver-faq/469946-change-uppercase-initial-caps.html

HTH,

Kent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.