2 Replies Latest reply: Sep 28, 2017 12:18 PM by youssef belloum RSS

    Filter data

    Amit Saini

      Hi Folks,

       

      I need filter help while loading the data. I'm trying below condition to not load the POSID where last digits are '000'

       

      Examples :

       

       

      C00001000
      C00002000
      C00003000
      C00004000
      C00005000
      C00006000

       

      where POSID <> right(POSID, 3) like '000'

       

      and second how to select a range KSTAR = 5000000 to 9999999  in where condition.


      Thanks,

      AS