I am having trouble getting the Concat(, ) function to work with 2 other set variables. I am in the TOAD automation editor and I have tried Concat(#String1#, #String2#) but I get errors saying "mismatched input ',' expecting )". Any help would be great, I have tried a lot of different formats.
Welcome to the TDP forum, Scott.
Have you tried surrounding the variable references with quotes? Can't recall if single or double quotes will do the trick.
Solution was : "#VariableName#" . A little strange from a programming perspective but it works! Thanks.