Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | Where Text Like Patterns
 
Where Text Like Patterns
You can define filter conditions in the Where clause for string columns based on a simple matching pattern using the like pattern keyword. The Like pattern uses the % symbol as a wildcard to represent zero to any number of characters and the _ symbol to represent a single character.
You can find an example of Like with a pattern using wildcards at the end in Group and Analyze Rows with Row Detail. This selects rows based on the stock symbol starting with either D% or N%.
You can also define patterns to match the end or middle of the string. For example:

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release