Instead, you would split this out into a proper_name table, which then has records mapping informal names to formal names. (Mike: Michael, Chris: Christopher, etc) You could then join that to the ...