title: Truncate and insert into string
body: <p>I have a string <code>abcdef</code>. I need truncate it to the result <code>def</code>, then insert into this string a new value <code>fff</code> to get the result <code>fffdef</code>. So far, I have used substring</p>
  
  <pre><code>UPDATE mytable
    SET col1 =
    SUBSTRING(col1, 3, LEN(col1))
  from
    mytable
  </code></pre>
  
  <p>But how I can insert to the beginning of the string value?</p>