Find all family names in Family that sound like “Joan”.
SELECT family_name FROM family WHERE SOUNDEX(TRIM(family.family_name)) = SOUNDEX('Joan'); family_name ----------- John Joan Joanne
Find all family names in Family that sound like “Joan”.
SELECT family_name FROM family WHERE SOUNDEX(TRIM(family.family_name)) = SOUNDEX('Joan'); family_name ----------- John Joan Joanne