the best way to remove spaces from a table is to remove them before they append to it - that's what validation is for!
That is a battle I have to take up with the IT department.. in my world that means writing up a ten page dissertation on why they need to fix it so that I don't have to spend an hour trying to clean up the data when I get it. Even then it will take six weeks and a blood sacrifice to some heathen god before they make the change.
Thanks for the tip though, I will try that out.
EDIT: good to go.. that worked just fine. Now to get to writing my data dissertation.