title: SQL: capitalize first letter only
body: <p>I need an SQL statement to capitalize the first letter of each word. The other characters have to be lower case.</p>
  
  <p>The words can be like this:</p>
  
  <pre><code>wezembeek-oppem
  roeselare
  BRUGGE
  louvain-la-neuve
  </code></pre>
  
  <p>Which would have to be:</p>
  
  <pre><code>Wezembeek-Oppem
  Roeselare
  Brugge
  Louvain-La-Neuve
  </code></pre>
  
  <p>This should be with an UPDATE statement, I want to update the data of a column.
  Thank you very much for your answers in advance, I'm an SQL novice.</p>