Reply to thread

Message: [QUOTE="Greg Collins, post: 1324646"] The translate() function works on a one-by-one character replacement. Thus the " " gets replaced with the "%" only. You will need to use something more complex (code) to accomplish what you want. Your construct is kind of weird too: translate(concat(field1, " ", field2), " ", "%20") Because the concat() happens before the translate() the space you are adding between the fields is going to get translated too. Maybe you meant: concat(translate(field1, " ", "%20"), " ", translate(field2, " ", "%20")) If not, then why not just: concat(field1, "%20", field2) [/QUOTE]