Concatenating Values in a Database with 'for each' with a delimiter

Dear all,

Is there a way to retrieve data using a 'for each' loop and insert a string between the values? For example:

I have the following values in a database table: child1, child2, ... child10.

My expected output is to concatenate 'and' between these values, like this: child1 and child2 and child3, ... and child10.

I would greatly appreciate your prompt assistance with this matter, as it is urgent.

Thank you.

Sincerely,