Supress Spaces

[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

 

[Les]

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

string.... Here's what I have

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.

 

[Guest]

Thanks !