4 Replies Latest reply on Jun 16, 2012 7:20 PM by marianco

    ExecuteSQL and concatenation

    ReneRos

      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