How do I qualify on an attribute using “Does not begin with”; “Does not contain” or “Does not end with” to exclude a list of character patterns?
Answer When qualifying on an attribute, you can find records that do not have a particular character pattern using the negative operators “Does not begin with”; “Does not contain”; and “Does not end with”. (For example, if you would like to exclude all records that begin with “A” or “B”, you can select “Does not begin with” and enter “A” and “B”). If you wish to exclude a list of characters or character sets, you can enter the list into the qualification box, but if you click on the List button, you’ll notice that the default for these negative operators is “Match Any”, just as it is for the positive operators. Running the query with “Match Any” selected will return results that include the character values you entered. To obtain results that exclude these records, select “Match All” in the list button before running the query. This will also work with “Does not contain”, and “Does not end with”. The desired results are returned with “Match All”, but not with “Match Any”. Steps to sele
