Trimming spaces

[Goalie3533]

I know you can remove leading and trailing spaces using LTrim or RTrim in a query however how would I go about removing any spaces from the middle of a string.
So, for instance, "How are you?" would become "Howareyou?".

Thanks in advance.

-Goalie35

 

[PHV]

Take a look at the Replace function.
Depending of your access version you may have to write your own public function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244