title: update data column with data from another column plus an additional keyword
body: <p>I have tried using a combination of both of these two previous questions <a href="https://stackoverflow.com/questions/5541916/how-to-insert-one-column-into-other-column-within-the-same-table-in-sql-server" title="Link 1">Question 1</a> <a href="https://stackoverflow.com/questions/5822694/create-mysql-column-with-string-variable-from-another-column-plus-additional-in" title="Link 2">Question 2</a> to help me with my issue.</p>
  
  <p>My issue is I am trying to set one column in DB2 equal to another column with a beginning and ending value.  I do have the option of doing this in two steps, of adding the S- first and then on a second pass add the -000 on the end, but I am currently running into the issue of CONCAT not working in DB2 like in MYSQL.</p>
  
  <p>Pre-conversion</p>
  
  <pre><code>name  |   loc      |  group
  -----------------------------------
  sam   |   123      |   
  jack  |   456      |   
  jill  |   987      |   
  mark  |   456      |   
  allen |   123      |   
  john  |   789      |   
  tom   |   123      |   
  </code></pre>
  
  <p>Post-conversion</p>
  
  <pre><code>name  |   loc      |  group
  -----------------------------------
  sam   |   123      |   S-123-000
  jack  |   456      |   S-456-000
  jill  |   987      |   S-987-000
  mark  |   456      |   S-456-000
  allen |   123      |   S-123-000
  john  |   789      |   S-789-000
  tom   |   123      |   S-123-000
  </code></pre>
  
  <p>The SQL I am trying to use:</p>
  
  <pre><code>UPDATE table 
  SET GROUP = CONCAT('S-',LOC,'-000') 
  WHERE LENGTH(RTRIM(LOC)) = 3
  </code></pre>
  
  <p>Any help or guidance would be appreciated.</p>