Skip navigation

'IN' Operator equivalent

score 406
You have not voted. Active

I would like an equivalent to the SQL 'IN' operator.  Currently the only way to compare a list of values is by using an OR operator.  This is very cumbersome when comparing a large list of values.

 

For example:

IF [Country]='HONDURAS' OR [Country]='MEXICO' OR [Country]='PERU' OR [Country]='COLUMBIA' OR [Country]='ARGENTINA' THEN 'AMERICAS' ELSE 'OTHER' END

 

What I am used to doing in SQL is this:

IF [Country] IN ('HONDURAS','MEXICO','PERU','COLUMBIA','ARGENTINA') THEN 'AMERICAS' ELSE 'OTHER' END

Comments