IN operator

[Aurél]

Hello,

In SQL we can use :
PRODUCT IN ('A','B','C')
For a reload script using REDISENT what can we replace the operator IN please?

Can we avoid doing this?:
PRODUCT = 'A' OR
PRODUCT = 'B' OR
PRODUCT = 'C'....

Thank you.

[Or · Accepted solution]

Match(Field,'Value1','Value2')

[Aamer_17 · Accepted solution]

Hi,

you can also use WildMatch(Field,'Value1','Value2',.....,'ValueN');

Hope this will also work.
Thanks