How might I go about creating a CONCAT function with more th

Question

How might I go about creating a CONCAT function with more than 2 characters

sam1128 · Answer

Use pipes field || field2 || field3

Nick · Answer

Thanks Sam