title: How to Append String at the end of a Given a Column in SQL Server?
body: <p>I have a project I am working on. based off a backup SQl Server database from a production server.  They have over 16,000 user email addresses, and I want to corrupt them so the system (which has automatic emailers) will not send any emails to valid addresses.  </p>
  
  <p>But I still want the users, and I want them in a way that I can reverse what I do (which is why I dont want to delete them).</p>
  
  <p>The SQL I am trying is:</p>
  
  <blockquote>
    <p>UPDATE    Contact SET<br>
    EmailAddress = EmailAddress + '.x'</p>
  </blockquote>
  
  <p>But it isnt working, what am I doing wrong?</p>
  
  <p>Error Message is as follows:</p>
  
  <pre><code>---------------------------
  Microsoft SQL Server Management Studio Express
  ---------------------------
  SQL Execution Error.
  
  Executed SQL statement: UPDATE Contact SET EmailAddress = EmailAddress + '.x'
  Error Source: .Net SqlClient Data Provider
  Error Message: String or binary data would be truncated. The statement has been terminated.
  ---------------------------
  OK   Help   
  ---------------------------
  </code></pre>