title: SQL Access, Concatenate fields within query
body: <p>is it possible to concatenate fields in my query using sql access(querying using excel).</p>
  
  <p>My current query is :</p>
  
  <pre><code> Select *
   FROM [table$]
  </code></pre>
  
  <p>But how do I add a new field which concatenates <code>colA&amp;"|"&amp;colB&amp;"|"&amp;colC&amp;"|"&amp;colD</code></p>
  
  <p>Thanks.</p>