Or, more directly - this is what happens when people who don't know
squat about designing data storage start storing data. No offense, but
there's a reason people get degrees in subjects like this.

Names (and other data) should generally be stored at the lowest level
and built into large units when needed. So, store Prefix, First Name,
Middle Initial, Last Name, Suffix all separately. Put them together
when needed.

If you have just a few names in your d/b, you can manually correct
them. If you have a lot of names, you will need to have someone write
some programming code to split them out. You will need to follow that
with a manual review to fix the odd balls.