Pattern Operators

Pattern operators allow text strings to be compared. Pattern operators are case-sensitive. The following pattern operators are available in MicroStrategy:

• Begins with: Returns a result set that starts with a specified value. For example, "begins with J" returns all strings beginning with J, including January, June, and July.
• Ends with: Returns a result set that ends with a specified value. For example, "end with r" returns all strings ending with r, including September, October, and all the other months meeting the criterion.
• Contains: Returns a result set that contains a specified value. For example, "contains ua" returns all strings that contain ua, such as January and February.
• Does not begin with: Returns a result set that does not start with a specified value. For example, "does not begin with J" returns only those values that do not begin with J, such as May, February, October, and so on.
• Does not end with: Returns a result set that does not end with a specified value. For example, "does not end with r" returns only those strings that do not end with r, such as March, April, and all the other months meeting the criterion.
• Does not contain: Returns a result set that does not contain a specified value. For example, "does not contain ua" returns only those values that do not contain ua, such as March, May, and so on.