I'm trying to use a function in the Formula Workshop to delimit data from a table. Previously I was using coalesce like below:

select res = coalesce(res + '|', '') + text
from MyTable;

I'm assuming that Crystal doesn't have the coalesce. Is there anything that I can use in replacement of coalesce to do the same.

Thanks,

Iris