instr() in SQLite compares bytes, so searching for a customer name in uppercase (e.g. "JOHN") silently missed lowercase-stored matches like "John". Lowercase both sides of the order number, name, and email comparisons so search matches regardless of the case staff paste in. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>