Use the Expression dialog box to formulate mathematical and alphanumeric expressions in several MapInfo Pro dialog boxes.
MapInfo Pro supports the use of the keywords "any", "all", "in" and "between". These keywords must be typed into expressions.
Use "any" to select any item in a set of items.
ABBR = any("AL", "MN", "TX")Any is true of any record where the state is Alabama, Minnesota, or Texas.
To understand the use of "all" consider this expression:
ABBR <> all("AL", "MN", "TX")This statement says: Give me all orders where the state does not equal Alabama, Minnesota, or Texas. It selects all orders except those from Alabama, Minnesota or Texas. Consider what happens when we issue the following:
ABBR <> any("AL", "MN", "TX")The following example shows the use of "in":
ABBR in("AL", "MN", "TX")In this case "in" is equivalent to "=any" and "not in" is equivalent to "<>all".
Finally, consider these two examples that illustrate "between":
PRICE between 50000 and 100000(PRICE between 50000 and 100000) or (PRICE between 150000 and 200000)