Search results

In given table name is formatted as: HERNANDEZ JR, FELIX / BRADY, ANDEL and I need to make it to "Felix Hernandez" How would I be able to clean up "/" , "JR," in my query.