title: How can i Remove \n (Char(10)) from specific string from starting & Ending of the string in ms sql
body: <p>I have one column for comment and I need to show this for one report. 
  Here what happen some time, users uses multiple enters in comment box. I can not access code part I need to manage this thing in SQL only. </p>
  
  <p>So I have removed unwanted</p>
  
  <pre><code>1 /r/n 
  2 /n/n
  </code></pre>
  
  <p>from using</p>
  
  <pre><code>REPLACE(REPLACE(Desc, CHAR(13)+CHAR(10), CHAR(10)),CHAR(10)+CHAR(10), CHAR(10)) as Desc,
  </code></pre>
  
  <p>Now I want to remove any <code>\r</code> or <code>\n</code> from <strong>starting or ending</strong> of the string if any</p>