title: Delete last N characters from field in a T-SQL Server database
body: <p>I have table of over 4 million rows and accidentally in one column there is more data than needed. </p>
  
  <p>For example instead of <code>ABC</code> there is <code>ABC DEFG</code>. </p>
  
  <p>How can I remove that N symbols using TSQL? Please note that I want to delete this characters from database, NOT just select substring. Thank you</p>