Cannot get WHERE statement to work in script..

[hopkinsc]

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;

Thanks

[#2 · Accepted solution]

hi Use Match() function...

where match([Stock Movement Reason Code],'1','2')

Hope that helps

Sravan