I have a huge database of CD Entries and some of the titles have a trailing space at the end of them.

For example:
(pretend that _ is a space)

I only want to remove the space at the end of the entrie, not the ones in the middle. So for this reason the replace function wont work for me. The space is messing up a lot of queries as the browser doesnt recognize them..

Is there an easy way to do this?