title: Get the first letter of each word in a SQL string
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/4865360/sql-to-pick-apart-a-string-of-a-persons-name-and-output-the-initials">sql to pick apart a string of a persons name and output the initials</a>  </p>
  </blockquote>
  
  
  
  <p>In <code>MS-SQL Server</code>, there is a way to get the first letter of each word in a string?  For example:</p>
  
  <p>Name: </p>
  
  <blockquote>
    <p>Michael Joseph Jackson</p>
  </blockquote>
  
  <p>Query: </p>
  
  <pre><code>SELECT name, [function] as initial FROM Customers
  </code></pre>
  
  <p>Result: </p>
  
  <blockquote>
    <p>MJJ</p>
  </blockquote>