2 Replies Latest reply: Mar 6, 2015 4:53 AM by Joaqu�n L�zaro RSS

    Where condition in a qvd load

    Joaqu�n L�zaro

      Hello:

       

      I wish to know if is possible write a IN or LIST condition instead a sequence of OR in a LOAD FROM QVD

       

      This is what I have

       

      MyFile:

      LOAD *

      FROM Myqvd.qvd (qvd)

      WHERE Field = 'A' or Field = 'B' or Field = 'C' ;

       

      This is what I would like

       

      MyFile:

      LOAD *

      FROM Myqvd.qvd (qvd)

      WHERE Field IN ( 'A', 'B', 'C') ;

       

      Thank you very much,

      Joaquín