title: Extract surname with initial in SQL Server
body: <p>In SQL Server, I have a column <code>NAME</code> with data like this:</p>
  
  <pre><code>1, CHAN Tai Man
  2, CHAN Ting Ting
  </code></pre>
  
  <p>I would like to have a query that extract the <code>NAME2</code> to</p>
  
  <pre><code>1, CHAN T M
  2, CHAN T T
  </code></pre>
  
  <p>As you may observe that only initial of the given name is required. How can I achieve that in SQL Server 2008? Many thanks for your gentle help.</p>