title: Concatenate string in Oracle SQL? (wm-concat)
body: <p>I've got some SQL that I'd like to format correctly for a mailout (generated directly from SQL - don't ask!). The code is as follows:</p>
  
  <pre><code>SELECT   wm_concat('&lt;br&gt;• ' || FIELD1 || ' ' || FIELD2 || ' : ' || FIELD 3 || ' text') AS "Team"
  </code></pre>
  
  <p>Okay, so this kinda works - but it places a comma at the end of each line. Silly question, and possibly quite trivial, but is there anyway at all to remove the comma please? I think it's being added by the wm_concat function</p>
  
  <p>Thanks</p>