Removing all spaces after the END of a specified string.

[THEGREEK]

Hi,

I was wondering if anyone knew an approach I could take regarding the above or maybe if there's a function I can use already that I'm not aware about...any help would be greatly appreciated

Here is an example of what i would like it do:

String Before: Manulife Financial[space][space][space]...
String After: Manulife Financial(leave any spaces in tact if they don't fall at the end of a string.)

 

[alley]

Use the Trim function. Ltrim to trim leading spaces, Rtrim to trim trailing spaces, and Trim for both.
alley