Substitute ( YourFIeldHere ; " " ; "+" )
Awesome. I knew that function had to be somewhere, just couldn't find it.
Still wrapping my head around all the various functions and trying to remember more of them.
FileMaker Help can be a pretty decent way to look up functions and you can even use Help to pull up a list of all functions with links to click to learn more about those that look interesting. I've picked up new tricks by learning of new functions any number of different times that way...