1 Reply Latest reply: Sep 28, 2011 7:23 AM by Sravan Puppala RSS

    Cannot get WHERE statement to work in script..

    Chris Hopkins

      Hi, I am trying to use a where statement in my script to only load in specific Stock Movement Codes but i can not get it to work.

      Can anyone help me please?


      I have tried ..


      FROM $(cFileName) (qvd) where [Stock Movement Reason Code]='1,2,19,21,22,34,35,62,3,5,16,18';


      FROM $(cFileName) (qvd) where [Stock Movement Reason Code]=('1,2,19,21,22,34,35,62,3,5,16,18');


      FROM $(cFileName) (qvd) where [Stock Movement Reason Code]=1,2,19,21,22,34,35,62,3,5,16,18;