I have a procedural language script where I want to loop through records returned from this query:

for record in (select account_id, array_to_string(account_name,',') account_nm from dataset_nm.table_nm) do ...

I’m returning the account_name array as a comma-separated string. However, I’d also like each of the values in that array to be amended when they’re returned.

For example, rather than return:

Smith,Jones,Clark

I want:

123Smith,123Jones,123Clark

How can I best achieve that?