title: How to concatenate strings in Teradata
body: <p>I use <code>Teradata 14</code> with all <code>strtok</code> and other new functions , but i am not allowed to write my own functions .</p>
  
  <p>In the following table each person has many skills . How can I concatenate those skills ? </p>
  
  <pre><code>team    person
  1       Mike (swi)
  1       Nick (dri)
  1       Mike (coo)
  2       
  3       Kate (swi)
  3       Kate (coo)
  3       Kate (dri)
  3       Wend (fly)
  4       Pete (jum)
  </code></pre>
  
  <hr>
  
  <p>Desired table is </p>
  
  <pre><code>team    person
  1       Mike (swi coo), Nick (dri),
  2       
  3       Kate (swi coo dri), Wend(fly),
  4       Pete (jum),
  </code></pre>
  
  <p>How can I concatenate strings ?</p>