title: ProperCase in SSIS where name has hyphen
body: <p>I am trying to transform the 'firstname' column from its initial state: all upper case (e.g. FLORIN, FLORIN-MIHAI) to proper case (e.g. Florin, Florin-Mihai).
  I`ve used the expression below</p>
  
  <pre><code>REPLACE(LEFT(FIRSTNAME,1) + LOWER(SUBSTRING(FIRSTNAME,2,100))," ","")
  </code></pre>
  
  <p>and it works for names without hyphen (e.g. FLORIN = Florin), but where my names have hyphen it doesn't  (FLORIN-MIHAI = Florin-Mihai and I am looking for Florin-Mihai).
  Is there a easy way to do this?  </p>