Enter a database filter expression that specifies the records to be kept or removed. The filter expression can be up to 510 characters.
A filter expression is usually in the format Function(expression 1, expression 2, etc...) in any combination of values (including CLP codes), variables, or operators that yield a single value when calculated. For a list of valid functions, see Calculations, Functions and Linkages.
Note: CaseView-specific functions cannot be included.
Examples:
Filter Type |
Filter Expression |
Effect |
Keep |
Length(trim(map_no))<10 |
Only map accounts with length less than 10 will be kept. (All map accounts with length greater or equal to 10 will be removed. |
Remove |
Left(map_no,2)="11" |
All map accounts that begin with "11" will be removed. |