- Published on
Back to basic, let's brush up on some `SQL` :)
At my company we have employees creating customer accounts every day.
Sometimes we make mistakes, for instance, we forget to check if the
company already was a customer (maybe 10y ago they may have had a product).
Duplicate accounts can cause all sorts of problems, so I wanted
way to detect them with `SQL`.
The problem was, the company names may have been entered with
different punctuation, whitespace,
etc. So I needed similar names to surface from the depths of our database,
not just exact matches (that would have been too easy :)