Previous Topic: Special Filtering Characters


Filtering Examples

The following are the various filtering specifications:

*

Matches any data.

LATE

Matches data equal to LATE.

QUE*

Matches data that starts with QUE.

*PAY*

Matches data that contains PAY.

*2000

Matches data that ends with 2000.

06*2000

Matches data that starts with 06 and ends with 2000.

W*RPT*

Matches data that starts with W and contains RPT.

*ACC*T*

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

?A*

Matches data that contains A in the second position.

???WKLY

Matches data that contains three characters followed by WKLY.

^*

Matches data that starts with a non blank character.