Suggestion for more Efficient/Elegant way to use IF(,OR OR OR...)

[BryanFontes]

Hey guys,

I currently have this LOAD statment:

LOAD 

ID,

AGE,

ESP,

...

FROM [] WHERE AGE>0 and AGE<120 and IF(ESP=('1') or ESP=('2') or ESP=('3') or ESP=('4') or ESP=('5') or ESP=('6') or ESP=('7') or ESP=('8') or ESP=('19') or ESP=('20') or ESP=('21') or ESP=('22') or ESP=('23') or ... ,'ok')='ok';

Is there any way to substitute this bunch of OR for something more elegant or less process-consuming?

[Thiago_Justen_ · Accepted solution]

Hi there,

There is a cool material here: If Tips by Rob Wunderlich 

Regards

[Vegar · Accepted solution]

You could replace your IF(ESP=('1').... expression with a Match() statement like this

WHERE AGE>0 and AGE<120 AND Match(ESP,1,2,3,4,5,6,7,8,19,20,21,22,23)

[BryanFontes]

Thanks!

[BryanFontes]

Thanks! I used exactly this