How to merge text records of one field
Lets say i have one table with one as text defined field which has 5 records
the field1 contains these records:
And i want to merge these records into another field (lets say table1::field2) which should only contain one record that extends if i add more records to field table1::field1
a \b \c \d \e
How can i do this?