13 Replies Latest reply: Oct 8, 2018 8:33 AM by youssef belloum RSS

    Function to Reverse String / text

    Sandra Pinto

      Hi

      I am getting revered string from my system. For Example Item ABCD is loaded as DCBA.

      Is there a function I can use to reverse the string, in the script itself?

       

      Here is the script:

      LIB CONNECT TO 'Sandra-Lavi (lavi_sandra)';

      Parts:

      LOAD

          Text(PARTNAME) as Parts.PARTNAME ;

      SQL SELECT

      PARTNAME,

      ....

      FROM lavi.dbo.PART;

       

      Thanks !!

      Sandra