title: Sql Server Editing Columns
body: <p>I have a problem in writing query in sql server 2008r2. </p>
  
  <p><strong>1.</strong> Name column has Words joined e.g.</p>
  
  <blockquote>
    <p>Er.Tom, Dr.Katty, Mr.Barney.</p>
  </blockquote>
  
  <p>How can I separate them in the same column with a ' '(space) i.e</p>
  
  <blockquote>
    <p>Er. Tom, Dr. Katty, Mr. Barney.</p>
  </blockquote>
  
  <p><strong>2.</strong> Name Column has words joined e.g.</p>
  
  <blockquote>
    <p>EngineerPete,EngineerSunny,EngineerRocky</p>
  </blockquote>
  
  <p>How can I separate them in the same column with a ' '(space) i.e</p>
  
  <blockquote>
    <p>Engineer Pete,Engineer Sunny,Engineer Rocky</p>
  </blockquote>
  
  <p>Thank You in advance </p>