Inserting + for a space

[idesdema]

Some sites have terrible formatting requirements for pulling feeds. For example, a site I'm trying to pull a feed from requires a plus sign in place of a space. For example, I'm trying to pull a feed based on the keyword (or phrase) Cache La Poudre. The feed makes me request it like this Cache+La+Poudre. Is there a way to take a query result and insert a plus sign wherever there is a space in the string?

[Miguel-F]

That can be done very easily using the Replace function. Something like:

Replace("Cache La Poudre"," ","+","All")

That first parameter can be a variable too. Like:

Replace(QueryResultField," ","+","All")

[idesdema]

Love it when I get answers quickly and see the word "easily".

Thanks. I just realized I can make my search results a little more refined based on this function.

Thanks again.