7 Replies Latest reply: Jan 24, 2014 10:15 AM by Clever Anjos RSS

    Query to SAP scritp with: " where right(OBJNR,7) > '1030000' "

      Hi everyone

       

      I got the the following select in my script:

       

      Load

         OBJNR,

         STAT,

         INACT,

         CHGNR;

      SQL Select OBJNR STAT INACT CHGNR  from JEST where right(OBJNR,7) > 1031000 ;

       

       

      The field OBJNR is like "OR0000001033466", and i just need to get where the last 7 numbers are > '1030000'.

       

      I want to make a where right(OBJNR,7) > '1030000' in the where clause. but does not work.

       

      I also try: where num(right(OBJNR,7)) >  '1030000'


      but doesn't work too.

       

      can anyone help me?