title: Converting a upper case database to proper case
body: <p>I am new to SQL and I have several large database with upper case first and last names that I need to convert to proper case in SQL sever 2008.</p>
  
  <p>I am using the following to do this:</p>
  
  <pre><code>update database 
  Set FirstNames = upper(substring(FirstNames, 1, 1))
                       + lower(substring(FirstNames, 2, (len(FirstNames) - 1) ))
  </code></pre>
  
  <p>I was wondering if there was any way to adapt this so that a field with two first names is also updated (currently I make the change and then go through and manually change the second name).</p>
  
  <p>I have looked over the other answers in this field and they all seem quit long, compared to the query above.</p>
  
  <p>Also is there any way to assist with converting the Mc suranmes ( I will manually change the others)? MCDONALD to McDonald, again I am just using the about query but replacing the FirstNames with LastName.</p>