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 '||'





      Field1 + ' - '  + Field2 AS Field3,





      FROM Table1


      The above script works through OLE DB for SQL Server.


      Some clue?


      Tks in advance.


      Rubens Rodrigues