Trimming Internal Spaces from a String

[J Bhujanga]

As my title implies, I have fields with text strings from which I want to remove ALL spaces, whether they be at the beginning, end or somewhere in between.
I can imagine various cumbersome approaches to this, involving searching for where the blanks are and chopping the string before and after and putting it back together. This all seems like too much work, especially when it can it can be any number of spaces that are in there.
However, my searches have yielded no function that will just do it. Is this really the case and I must do it the hard way?

[CJ_London]

the replace function should do what you require

replace(myString," ","")

[J Bhujanga]

Yep. It does indeed!
Thanks.