Concatenating Values in a Database with 'for each' with a delimiter
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.