Selecting and Retrieving Reports › Using Sorting and Filtering › Selection List Filtering › Filtering Examples

Filtering Examples

This list describes various filtering specifications:

*

Matches any data

DISK

Matches data equal to DISK

QUE*

Matches data starting with QUE

*PAY*

Matches data that contains PAY

*2013

Matches data that ends with 2013

11*2013

Matches data that starts with 11 and ends with 2013

W*RPT*

Matches data that start with W and contains RPT

*ACC*T*

Matches data that contains ACC and T (for example, ACCT and ACCOUNT)

?A*

Matches data that has A in the second position

???WKLY

Matches data that has three characters followed by WKLY

^*

Matches data that starts with a non-blank character

100000+

Matches values greater than or equal to 100000

2M+

Matches values greater than or equal to 2,000,000

2009-

Matches values less than or equal to 2009

15K-

Matches values less than or equal to 15,000

20K:50K

Matches values between 20,000 and 50,000