Data Modeling Uppercase and Lowercase issues

Hello,   I'm pulling data from a MYSQL server and among the data that I have there several entries which have similar input however they differ from each other by having some of the letters in thei...