SELECT Member name filter pattern masking

The following rules and examples apply to member name filter pattern masking on the SELECT statement.

The pattern masking characters are asterisk (*) and percent sign (%).
The asterisk character is used in the filter pattern mask to indicate that any characters within the member name that follow the pattern mask are acceptable.
The percent character is used in the filter pattern mask to indicate that any character within the member name in a particular position is acceptable.
The pattern must be part of a COPYGROUP operation.
The pattern must be part of a SELECT statement.
Filtering will only be performed with primary member names.

Examples of member name filter pattern usage appear in Table 1.

Table 1. Member name filter pattern examples
Member name pattern	Description	Examples of member names that would match	Examples of member names that would NOT match
*	Any member name	ABC, A12#$F	None
CD*	Member names starting with 'CD'	CDEFGH	ABCD
*CD	Member names ending with 'CD'	ABCD	CDEFGH
CD%	Three-character member names starting with 'CD'	CD$	CD, CDEFG
%CD	Member names with second character 'C' and third character 'D'	BCDE, $CD	CD, CDEFG
%CD*	Member names with second character 'C' and third character 'D'	BCD, BCDE, $CD	BBCDE, CD
*CD%	Member names with second to last character 'D' and third to last character 'C'	CDE, BCDE, BBCDE	CD
AB%C	Member names that have the substring 'AB', followed by any one character, followed by the substring 'C'	ABKC, KKABKCKK	ABC
%	Any one-character member name	A, B, C	ABC
%%	Any two-character member name	AB, BC, CD	ABC
**	Not a valid member name pattern	Not Applicable	Not Applicable