title: Trim spaces in string - LTRIM RTRIM not working
body: <p>I tried this code - </p>
  
  <pre><code>UPDATE Table
  SET Name = RTRIM(LTRIM(Name))
  </code></pre>
  
  <p>Data type of Name is <code>varchar(25)</code></p>
  
  <p>None of the leading and trailing spaces get removed. When I copy-paste one such <code>Name</code>, 
  i get this - </p>
  
  <pre><code>"big dash" "space symbol" ABC001
  </code></pre>
  
  <p>Why is this happening and how do trim the spaces ?</p>
  
  <p><strong>EDIT -</strong> </p>
  
  <p>The question has already been answered. I found one more table with this problem. I get 
  "- value" when i copy a column of a row. When I press the enter key at end of this copy-pasted value, i see more dashes. See image below - </p>
  
  <p><img src="https://i.stack.imgur.com/EuEnE.jpg" alt="Weird symbols"></p>