Wildcard Characters

A wildcard character is a single-character placeholder that represents one or more other characters. Use wildcards to broaden or limit the search results in KFS Lookups.

Character(s)

Function

Use with

Example

Explanation of Example

* or % Match on any character or characters Alphanumeric characters 103* or 103% Search for matches on all account numbers that start with 103 (10-300-00, 10-397-65, etc.).
| Or All types of data 1111500|1123400 Search for matches on either account 11-115-00 or account 11-234-00.
&& And All types of data 1111500&&1123400 Search for matches that contain both account 11-115-00 and account 11-234-00.
! Not equal to Alphanumeric characters !1031490 Search for matches on all account numbers except 10-314-90.
? Match on any single character Alphanumeric characters 130?490 Search for matches on all seven-digit account numbers that start with 103 and end with 490 (10-304-90, 10-314-90, etc.).
> Greater than Alphanumeric characters, numbers, and dates >1031490 Search for matches on all account numbers greater than 10-314-90.
< Less than Alphanumeric characters, numbers, and dates <1031490 Search for matches on all account numbers less than 10-314-90.
>= Greater than or equal to Alphanumeric characters, numbers, and dates >=1031490 Search for matches on all account numbers equal to or greater than 10-314-90.
<= Less than or equal to Alphanumeric characters, numbers, and dates <=1031490 Search for matches on all account numbers equal to or less than 10-314-90.
.. Between (inclusive range) Alphanumeric characters, numbers, and dates 1031490..1111500 Search for matches on all account numbers equal to or greater than 10-314-90 and equal to or less than 11-115-00.