title: Remove trailing ":" character from a row in a SQL table
body: <p>I have table with millions of rows. For each row, there is an nvarchar(max) column. When I populated the DB, I forgot to remove a trailing ":" character. What is the fastest / most efficient way to go  through each row and remove the last character?</p>
  
  <p>I'm thinking there must be a fastest way to do this than using REPLACE which seems expensive.</p>
  
  <p>This is SQL Server 2008</p>