ReneRos

ExecuteSQL and concatenation

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

Hi,

 

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

Outcomes