Need help in using IN function

[#1]

Hi,

Is it possible to use the IN fuction when loading a QVD.

When I try to use the IN function in the Where conditon its showing error.

Please advise...

Regards

Chriss

[jonathandienst · Accepted solution]

Hi

The QV script equivalent is Match(), eg

     Where City In  ('Cape Town', 'Johannesburg', 'Harare')

codes in QV like this:

     Where Match(City, 'Cape Town', 'Johannesburg', 'Harare')

Hope that helps

Jonathan

[#3]

Excellent Jonathan,

It works......