title: Remove blank space behind number in Access
body: <p>I have a column with a 7 digit number. When the data was imported there were 3 blank spaces imported behind each number. I have tried several different versions of Trim() in an update/select query with no luck. I am using Access 2007.</p>
  
  <p>Below are the different things I have tried:</p>
  
  <p>Select Query</p>
  
  <pre><code>Expr1: Trim([Number])
  Expr1: RTrim([Number])
  </code></pre>
  
  <p>and Update Query</p>
  
  <pre><code>UPDATE Table SET [Number] = Replace([Number], " ", "");
  </code></pre>
  
  <p><a href="http://office.microsoft.com/en-us/access-help/remove-spaces-from-the-beginning-and-end-of-a-text-value-HP001099033.aspx" rel="nofollow">http://office.microsoft.com/en-us/access-help/remove-spaces-from-the-beginning-and-end-of-a-text-value-HP001099033.aspx</a></p>