How to Use Wildcards

Below are examples of how to use wildcard characters with Like and Not Like:

• _ (Underscore) - When using this wildcard character with Like or Not Like, it returns any single character in that position. For example, CL_ _ _ along with the Like operator, would only return five character fields that start with CL.
• % (Percent) - When using "%" with the Like or Not Like operators, it returns any string of zero or more characters. If you were to choose the Not Like operator and enter the following criteria, you would get the following results:

Criteria	Result
%Organization%	Does not return data if "Organization" is any part of the message
Organization%	Does not return data that begins with "Organization"
%Organization	Does not return data that ends with "Organization"

Although % acts as a wildcard with the Like and Not Like operators, if you use it with any of the other operators (Equal to, Not Equal to, Greater Than, Less Than, Between, and Not Between), the system treats it as the literal percent character.