The following examples use wildcard symbols in the expression that can match any other text.
| Wildcard |
Description |
Example |
|---|---|---|
| % |
Use percent (%) as a substitute for multiple characters. Match all sales ledger accounts that start with a letter 'A'. |
SALES_LEDGER.ACCOUNT_REF LIKE "A%" |
| % |
Match all sales ledger accounts that end in the letter 'E'. |
SALES_LEDGER.ACCOUNT_REF LIKE "%E" |
| _ |
Use underscore (_) as a substitute for multiple characters. Match sales transactions SI, SC, SR, SA and so on. |
AUDIT_SPLIT.TYPE LIKE "S_" |
| _ |
Match sales accounts 400, 410, 420, 430, 450, 460, 470 and so on. |
SALES_LEDGER.ACCOUNT_REF LIKE "4_0" |