Replace all white space at the end of a string

[j1c]

Does anyone have an example of how to replace all whitespace at the end
of a string??

I'm trying something like:
do while right(str,1) = " "
str = replace(right(str,1)," ","")
loop
response.write("str:" & str)
.... but it is killing off the entire string ...

str:

 

[Bob Lehmann]

Look up the RTrim Function.

Bob Lehmann

 

[Mark Schupp]

do while right(str,1) = " "
str = right(str,len(str)-1)
loop

 

[Gérard Leclercq]

Mytext=Rtrim(Mytext)
Mytext=Ltrim(Mytext) 'left side
Mytext=Trim(Mytext) 'both

 

[j1c]

:| thanks Bob. that did the trick...

 

[j1c]

Thanks. RTim did the trick... not sure how I missed that one :|