You use parentheses for grouping clauses to form sub Percent character (Wildcard - Character(s) to Match) (Transact-SQL) _ Use the underscore character to match any single character in a string comparison operation that involves pattern matching. From the naming convention, you can see that the differentiation characteristic display/work role is encoded at position 5 of the technical role name. character as a wildcard to match any single character. To use the "-" character as part of the list, enter it at the beginning of the list. In WHERE conditions in Open SQL with the operator LIKE , ' %' stands for any string and ' _' for individual . Share. The meanings of these characters can differ between the two application areas, however, and thus often return surprising results during the analysis of datasets in the Data Browser (SUIM). The NOT logical operator can be used together with the wildcards to return rows that do not match the specified pattern. NOT Like. We use cookies and similar technologies to give you a better experience, improve performance, analyze traffic, and to personalize content. ! The naming conventions of the PFCG roles have the following structure in an SAP application client: Lets take a look at the example role YFI_C_XXXX:AA-POSTING: Postings in Asset Accounting. If you want more powerful wildcard and pattern matching for variable names, your best bet is to go back to proc sql as per the other part of my answer and use prxmatch ('/your_regex_here/', name) as part of your where clause rather than like. ! You can then use the Up and Down keys Use the underscore character _ to match any single character in a string comparison operation that involves pattern matching, such as LIKE and PATINDEX. For SAP experts worldwide, data display tools like the Data Browser (SE16), Quick Viewer (SQVI), and Query Start (SQ00) are basic components of their everyday work. + ) [ The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. , To perform a wild card sear for a string that begins with the search string, enter *