Which function can be used to append a string to ID fields (i.e., campaign_id) to prevent issues when reading the values in Excel?

The CONCAT function is used to combine two or more strings into a single string. When dealing with ID fields like campaignid that might contain very long numbers, Excel can sometimes misinterpret them as scientific notation or truncate them, leading to data loss or inaccuracies. Appending a non-numeric string (e.g., a prefix like 'ID') to these fields using CONCAT ensures Excel treats them as text, preserving their full value. SUM is an aggregate function used for adding numerical values. COLLECT is an aggregate function used to gather values into an array. Neither SUM nor COLLECT can append strings to prevent Excel formatting issues.