where clause criterion syntax

[#1]

I was a bit surprised when I tried -

load * from wherever.qvd where fieldname in (valuelist);

and got the "garbage after statement" error.  When I took out the "in" and replaced it with an equals sign it was happy.  Can I not use "in" in a load statement where clause?  Or did I get the syntax wrong?

Does anybody have the criterion syntax or a better way around this than lots of "or" statements?

Cheers,

Colin

[#2 · Accepted solution]

Hi

You can use

load * from wherever.qvd where match(fieldname,value1,value2,...);

[#3]

Blimey that was quick!  And it works, too.

Thankyou very much for your help.

[#4]

Thi was just what I needed... thanks