An even better question than that is how can combine different cleaning (I say cleaning because I want to clean commas out of generated lists by ExecuteSQL) function like Replace(), Substitute() Trim() etc.
Does anybody know why ExecuteSQL adds these double commas and commas with extra returns and things like that?
Substitute( INFORMATION::allfex ; [ ",,¶" ; "¶" ] ; [ ",¶" ; "¶" ] )
you can use as many as you need in this calculation
Nice! Thanks! I keep forgetting about brackets.