ExecuteSQL and concatenation

Discussion created by ReneRos on Jun 16, 2012
Latest reply on Dec 17, 2017 by beverly



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!


Best regards,
René Ros