Literal strings and tuple representations
Check patterns, prefixes, numeric text order and lossy tuple encoding.
Why does a literal underscore search return other codes?
Escape the literal part of a LIKE pattern.
Why does a BINARY code column still match lowercase prefixes with LIKE?
Choose a case-sensitive pattern operator for the supplied ASCII prefix.
Why does TRIM remove letters from the end of a report label?
Remove one exact prefix rather than a character set from both ends.
Why is nine sorted ahead of ten in a quantity export?
Sort validated quantity text numerically without rewriting identities.
Why do two different route pairs count as one?
Deduplicate the actual tuple rather than a separator-free concatenation.