title: RTRIM does not remove spaces at the end?
body: <p>I have used the Query:</p>
  
  <pre><code>    update Table
      set Seg = RTRIM(Seg)
  </code></pre>
  
  <p>This still doesn't remove the extra spaces at the end? I really need to remove this as I am doing vlookups in Excel and it is causing problems.</p>
  
  <p>The datatype of Seg column is (nchar(10), null)</p>
  
  <p>Any help is appreciated.</p>