Attorney leading zeros are (sometimes?) removed, creating duplicate records

[anastasia]

Not yet sure where this is happening first:

[anastasia]

SELECT *
FROM attorneys
WHERE name IN (SELECT name
                      FROM attorneys
                      GROUP BY name
                      HAVING COUNT(name) > 1);

Produces only four records, so two matches. Only one set with leading zeros!! Possibly I've found a needle in a haystack. Will post about the other case (bar numbers 416000 and 667109) in eviction attorneys repo

[ericrobskyhuntley]

Interesting... seems like this one is a pretty easy fix, though? Logic basically being where names match and bar numbers differ by a leading zero, discard one of the records, or possibly - if we want to be maybe unrealistically clean about it - separate the attorney from the address. It hurts me to say this, but maybe just satisfice here and pick the one from the more recent case?