A wildcard character is a single-character placeholder that represents one or more other characters. Use wildcards to broaden or limit the search results of KFS Lookups.
| Characters | 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 | 103?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 less than or equal to 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. |