Formula Workshop

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

AFAIK, COALESCE returns the first nonnull expression among a serie of arguments
Then you could try a serie of If-Then-Else

When I try to do any select statement in the function, I get an error message:

A number, currency amount, boolean, date, time, date-time, or string is expected here.