High Performance DE Substack

High Performance DE Substack

Handling Fuzzy Matching of Transactions Cleanly

Ditch Those Long-Winded Case Statements

High Performance DE Newsletter's avatar
High Performance DE Newsletter
Aug 15, 2025
∙ Paid
3
Share

We’ve all been there before. We inherit someone’s sql query, we crack it open, and we see a long winded case when statement that uses the like operator to categorize data. Something ugly like this:

Keep reading with a 7-day free trial

Subscribe to High Performance DE Substack to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Matt Martin
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture