Trying to concatenate a few fields with the SELECT statement using the ExecuteSQL works fine:
SELECT field1+field2+field3 FROM etc.
same effect has
SELECT field1||field2||field3 FROM etc.
I can't get SELECT CONCAT ( field1, field2, field3) FROM etc. to work but that is not the problem.
But how can I get fixed text in the result?
These trials with single and double quotes all fail:
SELECT field1+'-'+field2+'-'+field3 FROM etc.
SELECT field1+"-"+field2+"-"+field3 FROM etc.
Anyone has a suggestion? Thanks!