Getting rid of spaces

[dabdo555]

I have a string that I want to get rid of any blank spaces at the end of it. Example....

"John Doe "

to

"John Doe"

Is there a way to find the last character spot and then delete off the rest???

 

[LPlates]

String = Trim(String)

 

[dabdo555]

So....you think its that EASY ehhhh????....well....ehhhh....youre right....thank you!

 

[LPlates]

Have a good one!

Merry Xmas!

 

[SonOfEmidec1100]

dabdo555 sometime you may find these useful as well

Remove all spaces - Replace(MyString, " ", "&quot
Removes spaces from left - LTrim(MyString)
Removes spaces from right - RTrim(MyString)

Best wishes for 2004