title: How to remove a full stop from the end of data
body: <p>I need to <strong>update</strong> my table because a number of fields in a column have got a fullstop on the end, i need to remove this.</p>
  
  <p>So, in TableA, Field1: the data looks like </p>
  
  <pre><code>1002243.    
  1007053.    
  1007403.    
  1104098.    
  1110010.  
  </code></pre>
  
  <p><em>NOTE</em>: Not all the fields are the same length.</p>
  
  <p>I need to remove the full stops.</p>
  
  <p>Im using SQL Server 2005, cheers :)</p>