4 Replies Latest reply: Jan 16, 2014 7:21 AM by Rubens Rodrigues RSS

    How to concatenate fields in SQL Script when using SAP Connector?

    Rubens Rodrigues

      Hi folks,

       

      I'm trying to concatenate two fields in SQL script through a QvSAPConnector Provider, but I see it does not recognize SQL string operator '+', even the oracle one '||'

       

      Script:

       

      SQL SELECT

      Field1 + ' - '  + Field2 AS Field3,

      Field4,

      .

      .

      .

      FROM Table1

       

      The above script works through OLE DB for SQL Server.

       

      Some clue?

       

      Tks in advance.

       

      Rubens Rodrigues