Page Comparison

All types of data

1111500

1123400
Matches on either of these two account numbers:
1111500
1123400

&&

And

All types of data

1111500&&1123400
Matches on records that contain both of these account numbers:
1111500
1123400

!

Not equal to

Alphanumeric characters

!1031490
Matches on all account number except 1031490

?

Match on any single character

Alphanumeric characters

103?490
Matches on all seven-digit account numbers that start with 103 and end with 490 (1030490, 1031490, etc.)

*

Match on any character or characters

Alphanumeric characters

103*
Matches on all account numbers that start with 103 (1030000, 1039765, etc.)

>

Greater than

Alphanumeric characters

>1031490
Matches on all account numbers greater than 1031490

<

Less than

Alphanumeric characters, numbers, dates

<1031490
Matches on all account numbers less than 1031490

>=

Greater than or equal to

Alphanumeric characters, numbers, dates

>=1031490
Matches on all account numbers greater than or equal to 1031490

<=

Less than or equal to

Alphanumeric characters, numbers, dates

<=1031490
Matches on all account numbers less than or equal to 1031490

..

Between (inclusive range)

Alphanumeric characters, numbers, dates

1031490..1111500
Matches on account numbers equal to or greater than 1031490 and on account numbers less than or equal to 1111500