title: Add space between columns sql
body: <p>How can I join multiple fields and at the same time add space between each field? I have three fields and I joined them but I want to add space between the names and surnames.
  I have it that way.</p>
  
  <pre><code> select name+''+motherlastname+''+last name
   from dbo.employee
  </code></pre>