title: Remove trailing empty space in a field content
body: <p>I am using SQL server MSDE 2000. I have a field called <code>notes</code> of type nvarchar(65). </p>
  
  <p>The content is 'Something ' with an extra space after the content (quotes for clarity) in all the records. I used the following command.</p>
  
  <pre><code>UPDATE TABLE1 
     SET notes = RTRIM(LTRIM(notes))
  </code></pre>
  
  <p>But it does not work. Is there any alternate way to do it?</p>