Make CONCAT take an arbitrary number of arguments
Currently, CONCAT only takes 2 arguments, so you need to nest multiple CONCAT (or just use the & operator) if you want to concatenate multiple strings. This can be avoided if CONCAT could take any number of strings as arguments.
In general, users expect associative functions to take an arbitrary number of arguments.
Kenneth Barber commented
Good point, Gabriel. However, I think that my suggestion still holds. We might not need the CONCAT function at all to concatenate strings, but since the CONCAT function does exist, it might as well be given an upgrade.
Gabriel Michaud-Verreault commented
You can use the "+" operator. MyVar="Hello"+Var2+"World"+Var3