title: How to delete blank spaces on a string column
body: <p>I have a <code>nvarchar(2000)</code> column which may store a long text as below</p>
  
  <p><a href="https://i.stack.imgur.com/nfsbu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nfsbu.png" alt="blank rows after text"></a></p>
  
  <p>There are a lot of blank rows at end of text. Is there a way to delete these blank rows (<code>char(10)</code>)? </p>
  
  <p>Using <code>replace(column,char(10),'')</code> is not acceptable. I don't want to mess up the content above. How to delete these char(10) only at the end of text?</p>
  
  <p>I'm using SQL Server 2012.</p>
  
  <p>Many thanks!!!</p>