...
| Code Block | ||||
|---|---|---|---|---|
| ||||
-- Select all invoices where the supplier starts with 'ACM' and the index data field 'amount' is not NULL SELECT * FROM invoice WHERE supplier LIKE 'ACM%' AND amount IS NOT NULL; |
The LIKE expressions are limited by their number of included wildcards. Thus, a maximum number of 10 % and _ characters are allowed in one LIKE expression. The limit compliance is verified in the validation.
| Anchor | ||||
|---|---|---|---|---|
|
...