Filtering Using IN Function

The IN function can be used to find records within a schema that match one of several different values, e.g. Filtering customers who either have an ACORN type of 9, 11, or 14. When creating the expression, the IN function is placed in between the column that you want to evaluate and the range of values you want to filter by, enclosed in brackets.

Example Expression:

TableName.ColumnName IN (Value1, Value2, Value3, …)

To use the IN function:

• Open a browse on the schema you wish to use the function on by right clicking on it and selecting Open Browse

• Go to Browse then select Edit Browse

• Select Where

  
• Double-click on the column that you want to use for your filter

• The table and column name should then populate in the Expression box

• Type IN followed by the range of values, separated by commas, after the table and column name

• Your expression should look something like this:

• MASTER.BRANCH IN (4,5,6)

• Click on the Validate button, then select OK

Note: If your criteria are strings then use single quotes around the codes, for example ‘One’, ‘Two’, ‘Three’