Hi David. The CONTAINS command seems to be more similar to the LIKE command as it gives results if any part of a value is represented ?
What I am looking to do is list of values in an IF statement and get a TRUE on any of them when an exact match is found.
For Example, how would I shorten this statement:
IF [Country]='HONDURAS' OR [Country]='MEXICO' OR [Country]='PERU' THEN 'AMERICAS' ELSE 'OTHER' END
What I am used to doing in SQL is this:
IF [Country] IN ('HONDURAS','MEXICO','PERU') THEN 'AMERICAS' ELSE 'OTHER' END
Currently, the way to do this would by using OR in your calculation. I would recommend adding this to the Ideas section!