Supress Spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please give me a way to remove spaces from a string.... Here's what I hav

A Document number field that can be about any length. In trying to compare this document field against what should be the same field coming from another source I find that the compare fails when there are trailing spaces included in one of the tables. I want to run an update query that will remove the extra blank spaces from all records in the document number field. My compare ought to work then

Thanks for any advice !

Bill
 
Look at Trim functions. There is Trim, LTrim, and Rtrim.
They get rid of spaces.

-----Original Message-----
Can someone please give me a way to remove spaces from a
Click to expand...
string.... Here's what I have
A Document number field that can be about any length.
Click to expand...
In trying to compare this document field against what
should be the same field coming from another source I find
that the compare fails when there are trailing spaces
included in one of the tables. I want to run an update
query that will remove the extra blank spaces from all
records in the document number field. My compare ought to
work then.
 
Back
Top